PREVIEW / etf_30min / 2013-04-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-05.parquet
  size:    328 KB
  rows:    10,895

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-04-05 04:00:00	SPY	ETF	155.65	155.65	155.61	155.61	10600.0
2013-04-05 04:30:00	SPY	ETF	155.63	155.63	155.56	155.56	10900.0
2013-04-05 05:00:00	SPY	ETF	155.58	155.59	155.46	155.52	20760.0
2013-04-05 05:30:00	SPY	ETF	155.55	155.55	155.24	155.33	33500.0
2013-04-05 06:00:00	SPY	ETF	155.41	155.42	155.21	155.25	9100.0
2013-04-05 06:30:00	SPY	ETF	155.22	155.23	155.02	155.03	126755.0
2013-04-05 07:00:00	SPY	ETF	155.07	155.13	154.84	154.91	408229.0
2013-04-05 07:30:00	SPY	ETF	154.92	155.05	154.76	154.98	535612.0
2013-04-05 08:00:00	SPY	ETF	155.01	155.8	154.83	154.91	1062605.0
2013-04-05 08:30:00	SPY	ETF	154.91	155.05	153.78	153.93	6765354.0
2013-04-05 09:00:00	SPY	ETF	153.92	154.23	153.82	153.95	2648834.0
2013-04-05 09:30:00	SPY	ETF	153.95	154.32	153.77	153.96	25189969.0
2013-04-05 10:00:00	SPY	ETF	153.96	154.32	153.8	154.26	12996340.0
2013-04-05 10:30:00	SPY	ETF	154.265	154.5	154.08	154.3699	11794078.0
2013-04-05 11:00:00	SPY	ETF	154.37	154.69	154.35	154.53	12476647.0
2013-04-05 11:30:00	SPY	ETF	154.54	154.6	154.35	154.36	6687422.0
2013-04-05 12:00:00	SPY	ETF	154.35	154.445	154.27	154.34	5443921.0
2013-04-05 12:30:00	SPY	ETF	154.34	154.6	154.34	154.37	5283199.0
2013-04-05 13:00:00	SPY	ETF	154.375	154.72	154.34	154.67	5258354.0
2013-04-05 13:30:00	SPY	ETF	154.68	154.79	154.56	154.58	4993465.0
2013-04-05 14:00:00	SPY	ETF	154.58	154.73	154.5	154.69	4915577.0
2013-04-05 14:30:00	SPY	ETF	154.69	154.87	154.67	154.82	7848654.0
2013-04-05 15:00:00	SPY	ETF	154.829	154.829	154.61	154.7	6963097.0
2013-04-05 15:30:00	SPY	ETF	154.695	155.35	154.63	155.19	22800201.0
2013-04-05 16:00:00	SPY	ETF	155.18	155.872	154.5468	155.03	9805196.0
2013-04-05 16:30:00	SPY	ETF	155.04	155.872	155.03	155.13	3941877.0
2013-04-05 17:00:00	SPY	ETF	155.13	155.17	155.12	155.12	242910.0
2013-04-05 17:30:00	SPY	ETF	155.14	155.26	155.14	155.23	79887.0
2013-04-05 18:00:00	SPY	ETF	155.21	155.21	155.13	155.15	39833.0
2013-04-05 18:30:00	SPY	ETF	155.15	155.15	155.11	155.13	3081.0
2013-04-05 19:00:00	SPY	ETF	155.13	155.15	155.11	155.12	6090.0
2013-04-05 19:30:00	SPY	ETF	155.12	155.15	155.09	155.15	8767.0
2013-04-05 05:30:00	QQQ	ETF	68.06	68.06	68.06	68.06	15000.0
2013-04-05 06:00:00	QQQ	ETF	68.06	68.06	68.04	68.04	11380.0
2013-04-05 06:30:00	QQQ	ETF	68.0	68.0	67.93	68.0	21000.0
2013-04-05 07:00:00	QQQ	ETF	67.97	67.99	67.89	67.89	33205.0
2013-04-05 07:30:00	QQQ	ETF	67.9	67.92	67.85	67.91	42320.0
2013-04-05 08:00:00	QQQ	ETF	67.92	68.0	67.85	67.9	158274.0
2013-04-05 08:30:00	QQQ	ETF	67.86	67.9	67.39	67.44	1284697.0
2013-04-05 09:00:00	QQQ	ETF	67.46	67.56	67.31	67.35	850637.0
2013-04-05 09:30:00	QQQ	ETF	67.35	67.51	67.19	67.34	9015122.0
2013-04-05 10:00:00	QQQ	ETF	67.34	67.505	67.251	67.49	3118255.0
2013-04-05 10:30:00	QQQ	ETF	67.4999	67.62	67.415	67.58	4129735.0
2013-04-05 11:00:00	QQQ	ETF	67.57	67.72	67.57	67.61	3291383.0
2013-04-05 11:30:00	QQQ	ETF	67.6	67.65	67.551	67.56	946122.0
2013-04-05 12:00:00	QQQ	ETF	67.56	67.62	67.52	67.53	1126376.0
2013-04-05 12:30:00	QQQ	ETF	67.535	67.635	67.51	67.529	1899871.0
2013-04-05 13:00:00	QQQ	ETF	67.53	67.64	67.49	67.62	816420.0
2013-04-05 13:30:00	QQQ	ETF	67.63	67.67	67.56	67.57	2280346.0
2013-04-05 14:00:00	QQQ	ETF	67.57	67.67	67.52	67.65	1035866.0

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

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