PREVIEW / etf_30min / 2017-05-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-04.parquet
  size:    434 KB
  rows:    14,833

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
2017-05-04 04:00:00	SPY	ETF	238.6	238.88	238.6	238.86	13543.0
2017-05-04 04:30:00	SPY	ETF	238.9	238.91	238.85	238.9	16413.0
2017-05-04 05:00:00	SPY	ETF	238.89	239.15	238.89	239.13	15688.0
2017-05-04 05:30:00	SPY	ETF	239.12	239.14	239.05	239.11	11193.0
2017-05-04 06:00:00	SPY	ETF	239.11	239.13	239.06	239.11	46353.0
2017-05-04 06:30:00	SPY	ETF	239.14	239.15	239.05	239.08	14168.0
2017-05-04 07:00:00	SPY	ETF	239.12	239.25	239.12	239.14	125955.0
2017-05-04 07:30:00	SPY	ETF	239.15	239.16	239.08	239.12	60128.0
2017-05-04 08:00:00	SPY	ETF	239.16	239.21	239.0	239.07	285930.0
2017-05-04 08:30:00	SPY	ETF	239.07	239.12	238.79	238.88	389476.0
2017-05-04 09:00:00	SPY	ETF	238.86	238.96	238.7161	238.85	455614.0
2017-05-04 09:30:00	SPY	ETF	238.83	238.9225	238.27	238.41	5229635.0
2017-05-04 10:00:00	SPY	ETF	238.42	238.84	238.37	238.7709	4861460.0
2017-05-04 10:30:00	SPY	ETF	238.78	238.84	238.41	238.58	3651144.0
2017-05-04 11:00:00	SPY	ETF	238.575	238.66	238.45	238.56	4338737.0
2017-05-04 11:30:00	SPY	ETF	238.58	238.84	238.445	238.49	4755294.0
2017-05-04 12:00:00	SPY	ETF	238.5	238.54	237.78	238.06	7142225.0
2017-05-04 12:30:00	SPY	ETF	238.06	238.56	238.0	238.5	3421167.0
2017-05-04 13:00:00	SPY	ETF	238.5	238.61	238.36	238.4	2984025.0
2017-05-04 13:30:00	SPY	ETF	238.4	238.66	238.3	238.52	2521723.0
2017-05-04 14:00:00	SPY	ETF	238.5289	238.74	238.21	238.58	4564649.0
2017-05-04 14:30:00	SPY	ETF	238.57	238.77	238.43	238.5	2969130.0
2017-05-04 15:00:00	SPY	ETF	238.5	238.65	238.4	238.56	1893587.0
2017-05-04 15:30:00	SPY	ETF	238.55	238.795	238.53	238.75	7339833.0
2017-05-04 16:00:00	SPY	ETF	238.74	238.76	238.54	238.74	3135500.0
2017-05-04 16:30:00	SPY	ETF	238.71	238.82	238.52	238.79	255172.0
2017-05-04 17:00:00	SPY	ETF	238.79	238.83	238.73	238.76	123340.0
2017-05-04 17:30:00	SPY	ETF	238.76	238.8	238.73	238.74	151017.0
2017-05-04 18:00:00	SPY	ETF	238.74	238.74	238.66	238.66	62450.0
2017-05-04 18:30:00	SPY	ETF	238.7	238.71	238.7	238.7	6776.0
2017-05-04 19:00:00	SPY	ETF	238.72	238.74	238.7	238.74	600.0
2017-05-04 19:30:00	SPY	ETF	238.74	238.8	238.71	238.76	14423.0
2017-05-04 04:00:00	QQQ	ETF	137.04	137.04	137.04	137.04	8000.0
2017-05-04 04:30:00	QQQ	ETF	137.05	137.07	137.04	137.07	2797.0
2017-05-04 05:00:00	QQQ	ETF	137.1	137.16	137.09	137.16	1800.0
2017-05-04 05:30:00	QQQ	ETF	137.21	137.21	137.2	137.2	900.0
2017-05-04 06:00:00	QQQ	ETF	137.17	137.2	137.17	137.2	999.0
2017-05-04 06:30:00	QQQ	ETF	137.24	137.24	137.18	137.18	8797.0
2017-05-04 07:00:00	QQQ	ETF	137.22	137.29	137.22	137.28	28899.0
2017-05-04 07:30:00	QQQ	ETF	137.27	137.28	137.25	137.28	7290.0
2017-05-04 08:00:00	QQQ	ETF	137.2	137.28	137.2	137.25	33377.0
2017-05-04 08:30:00	QQQ	ETF	137.27	137.27	137.04	137.04	66977.0
2017-05-04 09:00:00	QQQ	ETF	137.03	137.05	136.95	137.0	65996.0
2017-05-04 09:30:00	QQQ	ETF	137.01	137.12	136.56	136.66	1945834.0
2017-05-04 10:00:00	QQQ	ETF	136.66	137.07	136.64	137.01	1258162.0
2017-05-04 10:30:00	QQQ	ETF	137.01	137.08	136.86	136.91	790043.0
2017-05-04 11:00:00	QQQ	ETF	136.91	137.43	136.87	137.0007	469147.0
2017-05-04 11:30:00	QQQ	ETF	137.01	137.2211	136.92	136.98	1005866.0
2017-05-04 12:00:00	QQQ	ETF	136.99	137.06	136.629	136.75	1431228.0
2017-05-04 12:30:00	QQQ	ETF	136.74	137.06	136.71	137.03	727752.0

> showing 50 of 14,833 rows — these rows as CSV

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