PREVIEW / etf_30min / 2011-08-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-10.parquet
  size:    308 KB
  rows:    10,198

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-08-10 04:00:00	SPY	ETF	117.26	117.26	116.3	116.5	32100.0
2011-08-10 04:30:00	SPY	ETF	116.5	117.0	116.49	117.0	145300.0
2011-08-10 05:00:00	SPY	ETF	117.0	117.77	117.0	117.77	18115.0
2011-08-10 05:30:00	SPY	ETF	117.82	117.82	117.27	117.31	2800.0
2011-08-10 06:00:00	SPY	ETF	117.27	117.4	117.05	117.38	32240.0
2011-08-10 06:30:00	SPY	ETF	117.39	117.49	117.11	117.2	113348.0
2011-08-10 07:00:00	SPY	ETF	117.2	117.36	116.6	116.6	2695766.0
2011-08-10 07:30:00	SPY	ETF	116.67	117.01	116.64	116.68	3040193.0
2011-08-10 08:00:00	SPY	ETF	116.7	117.44	116.34	116.48	4781153.0
2011-08-10 08:30:00	SPY	ETF	116.48	117.37	115.55	115.65	6403344.0
2011-08-10 09:00:00	SPY	ETF	115.64	115.86	114.76	115.26	9288391.0
2011-08-10 09:30:00	SPY	ETF	115.26	115.44	114.02	114.2	61602619.0
2011-08-10 10:00:00	SPY	ETF	114.19	114.71	112.79	113.49	61629919.0
2011-08-10 10:30:00	SPY	ETF	113.48	114.77	112.94	113.66	45094669.0
2011-08-10 11:00:00	SPY	ETF	113.64	113.99	112.72	112.99	36692710.0
2011-08-10 11:30:00	SPY	ETF	112.98	114.29	112.8	113.94	30923365.0
2011-08-10 12:00:00	SPY	ETF	113.93	114.55	113.6	113.71	27726190.0
2011-08-10 12:30:00	SPY	ETF	113.71	114.4	113.22	114.32	20088750.0
2011-08-10 13:00:00	SPY	ETF	114.31	114.56	113.42	114.05	22499802.0
2011-08-10 13:30:00	SPY	ETF	114.04	115.25	113.8	115.22	26305884.0
2011-08-10 14:00:00	SPY	ETF	115.22	116.28	114.83	115.615	40327211.0
2011-08-10 14:30:00	SPY	ETF	115.62	115.93	114.63	114.66	34031053.0
2011-08-10 15:00:00	SPY	ETF	114.66	114.91	113.61	113.84	42137385.0
2011-08-10 15:30:00	SPY	ETF	113.84	114.05	111.95	112.25	80050388.0
2011-08-10 16:00:00	SPY	ETF	112.24	117.4901	112.06	112.73	25458058.0
2011-08-10 16:30:00	SPY	ETF	112.79	117.4901	112.31	113.31	18585889.0
2011-08-10 17:00:00	SPY	ETF	113.3	113.3	112.74	112.76	16909158.0
2011-08-10 17:30:00	SPY	ETF	112.9	117.4901	112.3157	112.81	39161455.0
2011-08-10 18:00:00	SPY	ETF	112.78	112.8	112.28	112.5	824027.0
2011-08-10 18:30:00	SPY	ETF	112.5	117.4901	112.11	112.24	2087536.0
2011-08-10 19:00:00	SPY	ETF	112.24	112.97	112.22	112.5	548644.0
2011-08-10 19:30:00	SPY	ETF	112.58	112.95	112.49	112.95	142230.0
2011-08-10 04:00:00	QQQ	ETF	52.72	52.76	52.43	52.43	1466.0
2011-08-10 05:00:00	QQQ	ETF	52.8	52.8	52.8	52.8	2500.0
2011-08-10 05:30:00	QQQ	ETF	52.94	52.94	52.94	52.94	100.0
2011-08-10 06:00:00	QQQ	ETF	52.74	52.83	52.74	52.83	4550.0
2011-08-10 06:30:00	QQQ	ETF	52.84	52.84	52.8	52.8	758.0
2011-08-10 07:00:00	QQQ	ETF	52.61	52.65	52.41	52.44	38950.0
2011-08-10 07:30:00	QQQ	ETF	52.44	52.61	52.4	52.44	210035.0
2011-08-10 08:00:00	QQQ	ETF	52.45	52.73	52.25	52.3	3181648.0
2011-08-10 08:30:00	QQQ	ETF	52.3	52.31	51.92	51.94	1507691.0
2011-08-10 09:00:00	QQQ	ETF	51.93	52.06	51.7	51.82	2097229.0
2011-08-10 09:30:00	QQQ	ETF	51.83	51.96	51.37	51.5	23924276.0
2011-08-10 10:00:00	QQQ	ETF	51.51	51.74	51.04	51.275	21895838.0
2011-08-10 10:30:00	QQQ	ETF	51.28	51.81	51.08	51.36	14064306.0
2011-08-10 11:00:00	QQQ	ETF	51.36	51.51	50.98	51.16	9438839.0
2011-08-10 11:30:00	QQQ	ETF	51.17	51.77	51.13	51.61	10220773.0
2011-08-10 12:00:00	QQQ	ETF	51.61	51.9	51.5	51.5017	8112515.0
2011-08-10 12:30:00	QQQ	ETF	51.5	51.79	51.32	51.73	6055056.0
2011-08-10 13:00:00	QQQ	ETF	51.73	51.86	51.36	51.61	6775656.0

> showing 50 of 10,198 rows — these rows as CSV

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