PREVIEW / etf_30min / 2015-09-21

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-21.parquet
  size:    373 KB
  rows:    12,653

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
2015-09-21 04:00:00	SPY	ETF	195.57	195.7	195.27	195.7	6946.0
2015-09-21 04:30:00	SPY	ETF	195.86	196.38	195.85	196.29	13506.0
2015-09-21 05:00:00	SPY	ETF	196.39	196.4	196.26	196.32	133635.0
2015-09-21 05:30:00	SPY	ETF	196.35	196.49	196.22	196.33	21449.0
2015-09-21 06:00:00	SPY	ETF	196.34	196.37	195.95	196.14	10592.0
2015-09-21 06:30:00	SPY	ETF	196.21	196.36	195.99	196.27	13991.0
2015-09-21 07:00:00	SPY	ETF	196.27	196.88	196.27	196.88	153598.0
2015-09-21 07:30:00	SPY	ETF	196.8	197.24	196.8	197.12	429669.0
2015-09-21 08:00:00	SPY	ETF	197.1	197.2	195.1	196.98	688588.0
2015-09-21 08:30:00	SPY	ETF	196.98	197.07	196.79	196.84	984084.0
2015-09-21 09:00:00	SPY	ETF	196.84	196.85	196.19	196.42	1375983.0
2015-09-21 09:30:00	SPY	ETF	196.44	197.08	196.24	196.6089	11404020.0
2015-09-21 10:00:00	SPY	ETF	196.63	197.06	196.47	196.85	6163896.0
2015-09-21 10:30:00	SPY	ETF	196.85	197.68	196.835	197.35	9853508.0
2015-09-21 11:00:00	SPY	ETF	197.36	197.55	197.23	197.29	3714773.0
2015-09-21 11:30:00	SPY	ETF	197.29	197.37	196.41	196.53	7598106.0
2015-09-21 12:00:00	SPY	ETF	196.54	196.545	195.9	196.285	7339541.0
2015-09-21 12:30:00	SPY	ETF	196.28	196.29	195.21	195.44	7352139.0
2015-09-21 13:00:00	SPY	ETF	195.45	196.215	195.36	196.08	5792191.0
2015-09-21 13:30:00	SPY	ETF	196.09	196.46	195.84	195.92	3605385.0
2015-09-21 14:00:00	SPY	ETF	195.92	196.15	195.66	195.92	3370130.0
2015-09-21 14:30:00	SPY	ETF	195.93	196.88	195.78	196.7	5154493.0
2015-09-21 15:00:00	SPY	ETF	196.69	196.78	196.38	196.58	4925105.0
2015-09-21 15:30:00	SPY	ETF	196.58	196.67	195.855	196.46	15337894.0
2015-09-21 16:00:00	SPY	ETF	196.47	197.08	196.44	196.99	6647482.0
2015-09-21 16:30:00	SPY	ETF	196.99	197.17	196.46	197.11	2238653.0
2015-09-21 17:00:00	SPY	ETF	197.12	197.19	196.4865	197.15	312708.0
2015-09-21 17:30:00	SPY	ETF	197.16	197.18	197.15	197.17	104456.0
2015-09-21 18:00:00	SPY	ETF	197.16	197.19	196.97	196.99	65869.0
2015-09-21 18:30:00	SPY	ETF	197.0	197.01	196.95	196.98	52183.0
2015-09-21 19:00:00	SPY	ETF	196.96	197.04	196.92	196.94	124127.0
2015-09-21 19:30:00	SPY	ETF	196.98	197.13	196.98	197.13	163931.0
2015-09-21 04:00:00	QQQ	ETF	105.35	105.35	105.35	105.35	300.0
2015-09-21 04:30:00	QQQ	ETF	105.65	105.99	105.65	105.99	655.0
2015-09-21 05:00:00	QQQ	ETF	106.02	106.02	106.02	106.02	7000.0
2015-09-21 05:30:00	QQQ	ETF	106.0	106.0	105.95	105.96	1500.0
2015-09-21 06:00:00	QQQ	ETF	106.01	106.01	105.89	105.9	8870.0
2015-09-21 06:30:00	QQQ	ETF	105.92	105.92	105.8	105.9	150200.0
2015-09-21 07:00:00	QQQ	ETF	105.93	106.15	105.93	106.15	140727.0
2015-09-21 07:30:00	QQQ	ETF	106.25	106.38	106.25	106.35	98309.0
2015-09-21 08:00:00	QQQ	ETF	106.32	106.34	106.11	106.24	43218.0
2015-09-21 08:30:00	QQQ	ETF	106.26	106.28	106.14	106.17	98983.0
2015-09-21 09:00:00	QQQ	ETF	106.17	106.17	105.9	105.92	516051.0
2015-09-21 09:30:00	QQQ	ETF	105.93	106.19	105.71	105.97	3741241.0
2015-09-21 10:00:00	QQQ	ETF	105.98	106.24	105.89	106.13	1606515.0
2015-09-21 10:30:00	QQQ	ETF	106.14	106.55	106.13	106.3735	2180275.0
2015-09-21 11:00:00	QQQ	ETF	106.38	106.5	106.29	106.3	1299396.0
2015-09-21 11:30:00	QQQ	ETF	106.3	106.33	105.71	105.75	2238330.0
2015-09-21 12:00:00	QQQ	ETF	105.74	105.75	105.31	105.46	2897351.0
2015-09-21 12:30:00	QQQ	ETF	105.4699	105.47	104.73	104.88	3328034.0

> showing 50 of 12,653 rows — these rows as CSV

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