PREVIEW / etf_30min / 2012-07-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-09.parquet
  size:    274 KB
  rows:    9,228

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
2012-07-09 04:00:00	SPY	ETF	135.26	135.26	135.09	135.09	62600.0
2012-07-09 04:30:00	SPY	ETF	135.09	135.09	135.0	135.0	6726.0
2012-07-09 05:00:00	SPY	ETF	134.99	135.09	134.93	135.01	90478.0
2012-07-09 05:30:00	SPY	ETF	135.07	135.21	135.07	135.16	27600.0
2012-07-09 06:00:00	SPY	ETF	135.16	135.32	135.1	135.32	16550.0
2012-07-09 06:30:00	SPY	ETF	135.31	135.34	135.24	135.3	43381.0
2012-07-09 07:00:00	SPY	ETF	135.31	135.31	135.15	135.16	547516.0
2012-07-09 07:30:00	SPY	ETF	135.19	135.32	135.13	135.13	227813.0
2012-07-09 08:00:00	SPY	ETF	135.16	135.45	135.08	135.37	1257286.0
2012-07-09 08:30:00	SPY	ETF	135.37	135.45	135.25	135.35	1420652.0
2012-07-09 09:00:00	SPY	ETF	135.36	135.39	135.18	135.38	1023908.0
2012-07-09 09:30:00	SPY	ETF	135.38	135.57	134.93	135.03	12098147.0
2012-07-09 10:00:00	SPY	ETF	135.03	135.14	134.77	134.91	9369328.0
2012-07-09 10:30:00	SPY	ETF	134.91	135.28	134.79	135.18	7718467.0
2012-07-09 11:00:00	SPY	ETF	135.18	135.21	134.97	135.0406	6507908.0
2012-07-09 11:30:00	SPY	ETF	135.0484	135.1	134.7	134.73	5997431.0
2012-07-09 12:00:00	SPY	ETF	134.73	135.04	134.71	134.97	6703551.0
2012-07-09 12:30:00	SPY	ETF	134.97	135.04	134.82	134.87	3987007.0
2012-07-09 13:00:00	SPY	ETF	134.88	135.19	134.85	135.165	3241039.0
2012-07-09 13:30:00	SPY	ETF	135.1664	135.35	135.13	135.22	4974021.0
2012-07-09 14:00:00	SPY	ETF	135.22	135.25	134.97	135.02	5950234.0
2012-07-09 14:30:00	SPY	ETF	135.02	135.07	134.82	134.95	4654119.0
2012-07-09 15:00:00	SPY	ETF	134.95	135.22	134.93	135.18	5287002.0
2012-07-09 15:30:00	SPY	ETF	135.175	135.42	135.06	135.31	13219665.0
2012-07-09 16:00:00	SPY	ETF	135.32	135.55	135.3	135.44	5844238.0
2012-07-09 16:30:00	SPY	ETF	135.44	135.48	135.26	135.28	815345.0
2012-07-09 17:00:00	SPY	ETF	135.29	135.34	135.25	135.25	48532.0
2012-07-09 17:30:00	SPY	ETF	135.27	135.27	135.22	135.27	14391.0
2012-07-09 18:00:00	SPY	ETF	135.27	135.28	135.19	135.24	40648.0
2012-07-09 18:30:00	SPY	ETF	135.26	135.29	135.25	135.28	4475.0
2012-07-09 19:00:00	SPY	ETF	135.28	135.33	135.28	135.31	10970.0
2012-07-09 19:30:00	SPY	ETF	135.3	135.37	135.26	135.37	20798.0
2012-07-09 04:00:00	QQQ	ETF	64.01	64.01	63.86	63.86	1100.0
2012-07-09 06:00:00	QQQ	ETF	63.97	63.97	63.97	63.97	5000.0
2012-07-09 07:00:00	QQQ	ETF	63.99	63.99	63.93	63.95	8200.0
2012-07-09 07:30:00	QQQ	ETF	63.95	64.01	63.95	63.95	11796.0
2012-07-09 08:00:00	QQQ	ETF	63.96	64.08	63.94	64.06	828124.0
2012-07-09 08:30:00	QQQ	ETF	64.06	64.1	64.03	64.03	85060.0
2012-07-09 09:00:00	QQQ	ETF	64.06	64.07	64.0	64.04	143139.0
2012-07-09 09:30:00	QQQ	ETF	64.03	64.26	63.85	63.87	3390223.0
2012-07-09 10:00:00	QQQ	ETF	63.87	63.92	63.74	63.8	4306851.0
2012-07-09 10:30:00	QQQ	ETF	63.79	64.0	63.68	63.97	3499486.0
2012-07-09 11:00:00	QQQ	ETF	63.97	63.98	63.87	63.92	2782712.0
2012-07-09 11:30:00	QQQ	ETF	63.92	63.94	63.695	63.7	1608534.0
2012-07-09 12:00:00	QQQ	ETF	63.7	63.84	63.69	63.79	1252574.0
2012-07-09 12:30:00	QQQ	ETF	63.8	63.85	63.73	63.8	1033344.0
2012-07-09 13:00:00	QQQ	ETF	63.8	63.97	63.78	63.97	1470061.0
2012-07-09 13:30:00	QQQ	ETF	63.97	64.07	63.94	64.0	1877151.0
2012-07-09 14:00:00	QQQ	ETF	64.0	64.02	63.86	63.88	2560788.0
2012-07-09 14:30:00	QQQ	ETF	63.89	63.91	63.74	63.83	691610.0

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

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