PREVIEW / etf_30min / 2011-04-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-05.parquet
  size:    277 KB
  rows:    9,292

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-04-05 04:00:00	SPY	ETF	133.18	133.18	132.76	132.9	4125.0
2011-04-05 04:30:00	SPY	ETF	132.83	132.93	132.83	132.89	500.0
2011-04-05 05:00:00	SPY	ETF	132.98	132.98	132.86	132.9	18525.0
2011-04-05 05:30:00	SPY	ETF	132.9	132.97	132.82	132.82	11600.0
2011-04-05 06:00:00	SPY	ETF	132.8	132.91	132.77	132.77	44100.0
2011-04-05 06:30:00	SPY	ETF	132.79	132.9	132.79	132.85	41900.0
2011-04-05 07:00:00	SPY	ETF	132.87	132.98	132.84	132.92	71550.0
2011-04-05 07:30:00	SPY	ETF	132.92	133.08	132.84	132.96	178075.0
2011-04-05 08:00:00	SPY	ETF	132.99	133.04	132.73	132.99	483824.0
2011-04-05 08:30:00	SPY	ETF	132.99	132.99	132.77	132.89	631318.0
2011-04-05 09:00:00	SPY	ETF	132.9	133.03	132.88	132.98	648296.0
2011-04-05 09:30:00	SPY	ETF	133.0	133.27	132.94	133.19	12783195.0
2011-04-05 10:00:00	SPY	ETF	133.18	133.47	132.97	133.39	11897657.0
2011-04-05 10:30:00	SPY	ETF	133.4	133.6	133.35	133.41	9210288.0
2011-04-05 11:00:00	SPY	ETF	133.42	133.54	133.35	133.51	5704351.0
2011-04-05 11:30:00	SPY	ETF	133.5079	133.76	133.4	133.7	9437543.0
2011-04-05 12:00:00	SPY	ETF	133.7	133.77	133.59	133.65	5398228.0
2011-04-05 12:30:00	SPY	ETF	133.65	133.75	133.57	133.695	7165404.0
2011-04-05 13:00:00	SPY	ETF	133.7	133.83	133.65	133.71	5455175.0
2011-04-05 13:30:00	SPY	ETF	133.71	133.73	133.64	133.65	4808698.0
2011-04-05 14:00:00	SPY	ETF	133.65	133.73	133.47	133.61	7979632.0
2011-04-05 14:30:00	SPY	ETF	133.609	133.66	133.36	133.479	6737241.0
2011-04-05 15:00:00	SPY	ETF	133.48	133.51	133.22	133.3	7016335.0
2011-04-05 15:30:00	SPY	ETF	133.3	133.33	133.11	133.22	14478775.0
2011-04-05 16:00:00	SPY	ETF	133.21	133.578	133.08	133.09	9056242.0
2011-04-05 16:30:00	SPY	ETF	133.1	133.4432	133.05	133.06	1057239.0
2011-04-05 17:00:00	SPY	ETF	133.07	133.11	133.07	133.11	209732.0
2011-04-05 17:30:00	SPY	ETF	133.12	133.12	133.07	133.1	15625.0
2011-04-05 18:00:00	SPY	ETF	133.1	133.24	133.1	133.17	181253.0
2011-04-05 18:30:00	SPY	ETF	133.17	133.21	133.17	133.21	82502.0
2011-04-05 19:00:00	SPY	ETF	133.2	133.21	133.16	133.21	15340.0
2011-04-05 19:30:00	SPY	ETF	133.21	133.22	133.17	133.19	25491.0
2011-04-05 04:00:00	QQQ	ETF	57.31	57.31	57.07	57.07	1973.0
2011-04-05 04:30:00	QQQ	ETF	57.02	57.02	57.02	57.02	100.0
2011-04-05 05:00:00	QQQ	ETF	57.05	57.07	57.01	57.01	30300.0
2011-04-05 05:30:00	QQQ	ETF	57.04	57.06	57.04	57.06	1000.0
2011-04-05 06:00:00	QQQ	ETF	56.98	57.0	56.9	57.0	9800.0
2011-04-05 06:30:00	QQQ	ETF	57.01	57.02	57.0	57.01	1260.0
2011-04-05 07:00:00	QQQ	ETF	57.03	57.12	57.01	57.08	201358.0
2011-04-05 07:30:00	QQQ	ETF	57.08	57.13	57.07	57.09	151804.0
2011-04-05 08:00:00	QQQ	ETF	57.09	57.16	57.06	57.13	506573.0
2011-04-05 08:30:00	QQQ	ETF	57.13	57.14	57.06	57.13	829852.0
2011-04-05 09:00:00	QQQ	ETF	57.13	57.21	57.12	57.15	1191135.0
2011-04-05 09:30:00	QQQ	ETF	57.16	57.28	57.07	57.19	6787439.0
2011-04-05 10:00:00	QQQ	ETF	57.19	57.36	57.06	57.33	5484968.0
2011-04-05 10:30:00	QQQ	ETF	57.321	57.46	57.32	57.41	4124923.0
2011-04-05 11:00:00	QQQ	ETF	57.42	57.4538	57.36	57.37	1808785.0
2011-04-05 11:30:00	QQQ	ETF	57.38	57.45	57.31	57.429	2343609.0
2011-04-05 12:00:00	QQQ	ETF	57.4299	57.445	57.36	57.3951	1397872.0
2011-04-05 12:30:00	QQQ	ETF	57.4	57.46	57.365	57.44	2574231.0

> showing 50 of 9,292 rows — these rows as CSV

> unlock the full archive -- $79 one-time