PREVIEW / etf_30min / 2018-01-03

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-03.parquet
  size:    485 KB
  rows:    16,638

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
2018-01-03 04:00:00	SPY	ETF	268.95	269.04	268.95	269.0	2381.0
2018-01-03 04:30:00	SPY	ETF	268.98	268.98	268.98	268.98	500.0
2018-01-03 05:00:00	SPY	ETF	268.98	268.98	268.98	268.98	300.0
2018-01-03 05:30:00	SPY	ETF	269.02	269.09	269.02	269.05	6200.0
2018-01-03 06:00:00	SPY	ETF	269.1	269.15	269.06	269.06	4360.0
2018-01-03 06:30:00	SPY	ETF	269.02	269.02	268.96	268.97	21100.0
2018-01-03 07:00:00	SPY	ETF	268.99	269.01	268.9	268.92	125350.0
2018-01-03 07:30:00	SPY	ETF	268.91	269.06	268.87	269.0	122470.0
2018-01-03 08:00:00	SPY	ETF	268.93	269.0	268.84	268.91	146027.0
2018-01-03 08:30:00	SPY	ETF	268.93	269.01	268.9	268.9	130439.0
2018-01-03 09:00:00	SPY	ETF	268.94	269.07	268.91	268.98	309761.0
2018-01-03 09:30:00	SPY	ETF	268.96	269.61	268.96	269.56	6725743.0
2018-01-03 10:00:00	SPY	ETF	269.565	269.94	269.54	269.89	8180338.0
2018-01-03 10:30:00	SPY	ETF	269.89	270.07	269.73	269.84	4862628.0
2018-01-03 11:00:00	SPY	ETF	269.845	269.975	269.765	269.92	3254250.0
2018-01-03 11:30:00	SPY	ETF	269.92	270.0	269.82	269.856	3221643.0
2018-01-03 12:00:00	SPY	ETF	269.86	270.05	269.86	270.045	2514515.0
2018-01-03 12:30:00	SPY	ETF	270.05	270.46	270.03	270.315	4092480.0
2018-01-03 13:00:00	SPY	ETF	270.32	270.36	270.265	270.27	5371179.0
2018-01-03 13:30:00	SPY	ETF	270.27	270.281	269.97	270.04	3435657.0
2018-01-03 14:00:00	SPY	ETF	270.035	270.24	269.99	270.21	4819847.0
2018-01-03 14:30:00	SPY	ETF	270.21	270.36	270.1401	270.275	3625639.0
2018-01-03 15:00:00	SPY	ETF	270.275	270.37	270.2	270.36	3110044.0
2018-01-03 15:30:00	SPY	ETF	270.36	270.64	270.33	270.47	14361964.0
2018-01-03 16:00:00	SPY	ETF	270.47	270.52	270.28	270.35	13454889.0
2018-01-03 16:30:00	SPY	ETF	270.34	270.47	270.11	270.21	3903805.0
2018-01-03 17:00:00	SPY	ETF	270.23	270.32	269.0832	270.25	118266.0
2018-01-03 17:30:00	SPY	ETF	270.25	270.47	270.21	270.27	914415.0
2018-01-03 18:00:00	SPY	ETF	270.27	270.29	270.2	270.25	62160.0
2018-01-03 18:30:00	SPY	ETF	270.2	270.47	270.15	270.28	609873.0
2018-01-03 19:00:00	SPY	ETF	270.29	270.47	270.27	270.27	14705.0
2018-01-03 19:30:00	SPY	ETF	270.28	270.31	270.22	270.3	23020.0
2018-01-03 04:00:00	QQQ	ETF	158.55	158.7	158.55	158.64	11418.0
2018-01-03 04:30:00	QQQ	ETF	158.64	158.69	158.62	158.69	7794.0
2018-01-03 05:00:00	QQQ	ETF	158.62	158.63	158.62	158.63	2100.0
2018-01-03 05:30:00	QQQ	ETF	158.66	158.66	158.65	158.65	300.0
2018-01-03 06:00:00	QQQ	ETF	158.66	158.68	158.66	158.67	3500.0
2018-01-03 06:30:00	QQQ	ETF	158.65	158.67	158.63	158.63	4600.0
2018-01-03 07:00:00	QQQ	ETF	158.62	158.62	158.56	158.57	30753.0
2018-01-03 07:30:00	QQQ	ETF	158.56	158.59	158.53	158.58	21798.0
2018-01-03 08:00:00	QQQ	ETF	158.63	158.63	158.52	158.54	30428.0
2018-01-03 08:30:00	QQQ	ETF	158.54	158.57	158.48	158.48	95354.0
2018-01-03 09:00:00	QQQ	ETF	158.5	158.71	158.5	158.63	81649.0
2018-01-03 09:30:00	QQQ	ETF	158.62	159.4634	158.61	159.43	4866190.0
2018-01-03 10:00:00	QQQ	ETF	159.43	159.63	159.35	159.47	1820572.0
2018-01-03 10:30:00	QQQ	ETF	159.48	159.75	159.45	159.67	1290524.0
2018-01-03 11:00:00	QQQ	ETF	159.67	159.85	159.56	159.81	1603569.0
2018-01-03 11:30:00	QQQ	ETF	159.81	159.86	159.69	159.7	1309779.0
2018-01-03 12:00:00	QQQ	ETF	159.7	159.84	159.7	159.83	570965.0
2018-01-03 12:30:00	QQQ	ETF	159.84	160.12	159.82	160.0361	1285269.0

> showing 50 of 16,638 rows — these rows as CSV

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