PREVIEW / etf_30min / 2013-07-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-19.parquet
  size:    306 KB
  rows:    10,491

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
2013-07-19 04:00:00	SPY	ETF	168.2	168.3	168.2	168.24	9751.0
2013-07-19 04:30:00	SPY	ETF	168.21	168.21	168.19	168.19	5709.0
2013-07-19 05:00:00	SPY	ETF	168.16	168.26	168.15	168.26	4494.0
2013-07-19 05:30:00	SPY	ETF	168.26	168.36	168.24	168.33	14900.0
2013-07-19 06:00:00	SPY	ETF	168.36	168.38	168.34	168.36	11000.0
2013-07-19 06:30:00	SPY	ETF	168.34	168.41	168.31	168.34	40420.0
2013-07-19 07:00:00	SPY	ETF	168.34	168.64	168.3	168.54	182794.0
2013-07-19 07:30:00	SPY	ETF	168.55	168.64	168.48	168.53	87575.0
2013-07-19 08:00:00	SPY	ETF	168.51	168.64	168.34	168.41	181283.0
2013-07-19 08:30:00	SPY	ETF	168.41	168.46	168.28	168.33	485889.0
2013-07-19 09:00:00	SPY	ETF	168.33	168.52	168.16	168.52	2525456.0
2013-07-19 09:30:00	SPY	ETF	168.52	168.68	168.31	168.48	15490435.0
2013-07-19 10:00:00	SPY	ETF	168.49	168.7	168.38	168.54	9824386.0
2013-07-19 10:30:00	SPY	ETF	168.53	168.81	168.51	168.73	6588429.0
2013-07-19 11:00:00	SPY	ETF	168.73	168.92	168.62	168.891	5587005.0
2013-07-19 11:30:00	SPY	ETF	168.89	168.9	168.61	168.7	5567237.0
2013-07-19 12:00:00	SPY	ETF	168.71	168.81	168.66	168.71	3835577.0
2013-07-19 12:30:00	SPY	ETF	168.71	168.74	168.64	168.72	4715836.0
2013-07-19 13:00:00	SPY	ETF	168.73	168.83	168.67	168.7	3410076.0
2013-07-19 13:30:00	SPY	ETF	168.7088	168.87	168.67	168.825	3160438.0
2013-07-19 14:00:00	SPY	ETF	168.829	169.06	168.8	169.01	5085024.0
2013-07-19 14:30:00	SPY	ETF	169.01	169.02	168.88	168.92	3817444.0
2013-07-19 15:00:00	SPY	ETF	168.92	169.01	168.9	168.95	6965724.0
2013-07-19 15:30:00	SPY	ETF	168.96	169.19	168.95	169.17	15127518.0
2013-07-19 16:00:00	SPY	ETF	169.18	169.48	168.5109	169.43	8072667.0
2013-07-19 16:30:00	SPY	ETF	169.42	169.47	169.4	169.44	478214.0
2013-07-19 17:00:00	SPY	ETF	169.43	169.48	168.8761	169.48	185507.0
2013-07-19 17:30:00	SPY	ETF	169.45	169.49	169.45	169.45	12494.0
2013-07-19 18:00:00	SPY	ETF	169.47	169.61	169.47	169.58	69866.0
2013-07-19 18:30:00	SPY	ETF	169.54	169.57	169.5	169.51	18210.0
2013-07-19 19:00:00	SPY	ETF	169.5	169.53	169.48	169.5	5356.0
2013-07-19 19:30:00	SPY	ETF	169.48	169.6	169.47	169.6	29073.0
2013-07-19 04:00:00	QQQ	ETF	75.24	75.24	74.64	74.68	25400.0
2013-07-19 04:30:00	QQQ	ETF	74.66	74.66	74.62	74.62	1800.0
2013-07-19 05:00:00	QQQ	ETF	74.6	74.6	74.58	74.6	2600.0
2013-07-19 05:30:00	QQQ	ETF	74.6	74.63	74.58	74.63	1685.0
2013-07-19 06:00:00	QQQ	ETF	74.63	74.63	74.62	74.62	550.0
2013-07-19 06:30:00	QQQ	ETF	74.61	74.64	74.61	74.63	1200.0
2013-07-19 07:00:00	QQQ	ETF	74.64	74.77	74.64	74.75	70177.0
2013-07-19 07:30:00	QQQ	ETF	74.77	74.78	74.76	74.77	5200.0
2013-07-19 08:00:00	QQQ	ETF	74.67	74.77	74.65	74.75	133346.0
2013-07-19 08:30:00	QQQ	ETF	74.75	74.77	74.7	74.72	127860.0
2013-07-19 09:00:00	QQQ	ETF	74.72	74.74	74.6	74.74	801334.0
2013-07-19 09:30:00	QQQ	ETF	74.72	74.74	74.48	74.55	7972292.0
2013-07-19 10:00:00	QQQ	ETF	74.55	74.62	74.43	74.51	2290520.0
2013-07-19 10:30:00	QQQ	ETF	74.5	74.649	74.47	74.55	3649295.0
2013-07-19 11:00:00	QQQ	ETF	74.55	74.66	74.53	74.6199	2937094.0
2013-07-19 11:30:00	QQQ	ETF	74.61	74.61	74.391	74.44	2002203.0
2013-07-19 12:00:00	QQQ	ETF	74.45	74.52	74.42	74.47	1049004.0
2013-07-19 12:30:00	QQQ	ETF	74.48	74.48	74.39	74.46	405319.0

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

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