PREVIEW / etf_30min / 2019-03-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-05.parquet
  size:    486 KB
  rows:    17,013

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
2019-03-05 04:00:00	SPY	ETF	279.77	279.94	279.75	279.94	13692.0
2019-03-05 04:30:00	SPY	ETF	279.78	279.83	279.77	279.83	400.0
2019-03-05 05:00:00	SPY	ETF	279.92	279.92	279.69	279.71	2760.0
2019-03-05 05:30:00	SPY	ETF	279.75	279.75	279.6	279.74	2732.0
2019-03-05 06:00:00	SPY	ETF	279.64	279.64	279.5	279.58	4162.0
2019-03-05 06:30:00	SPY	ETF	279.61	279.67	279.6	279.67	3706.0
2019-03-05 07:00:00	SPY	ETF	279.7	279.74	279.31	279.41	135302.0
2019-03-05 07:30:00	SPY	ETF	279.45	279.47	279.18	279.25	69829.0
2019-03-05 08:00:00	SPY	ETF	279.3301	279.75	279.21	279.53	79355.0
2019-03-05 08:30:00	SPY	ETF	279.58	279.71	279.35	279.35	84099.0
2019-03-05 09:00:00	SPY	ETF	279.35	279.59	279.32	279.54	314845.0
2019-03-05 09:30:00	SPY	ETF	279.54	279.57	278.41	278.72	6451305.0
2019-03-05 10:00:00	SPY	ETF	278.72	279.42	278.55	278.79	4953604.0
2019-03-05 10:30:00	SPY	ETF	278.79	279.25	278.6	278.835	3659802.0
2019-03-05 11:00:00	SPY	ETF	278.85	279.43	278.7	279.29	4997608.0
2019-03-05 11:30:00	SPY	ETF	279.29	279.68	279.11	279.27	3572893.0
2019-03-05 12:00:00	SPY	ETF	279.27	279.4	279.05	279.18	1858870.0
2019-03-05 12:30:00	SPY	ETF	279.19	279.34	279.06	279.3299	1595189.0
2019-03-05 13:00:00	SPY	ETF	279.3285	279.61	278.95	278.97	1758947.0
2019-03-05 13:30:00	SPY	ETF	278.975	279.2	278.87	279.16	2945365.0
2019-03-05 14:00:00	SPY	ETF	279.16	279.45	279.1	279.41	1471249.0
2019-03-05 14:30:00	SPY	ETF	279.41	279.68	279.26	279.64	2260072.0
2019-03-05 15:00:00	SPY	ETF	279.64	279.69	279.27	279.325	3003947.0
2019-03-05 15:30:00	SPY	ETF	279.32	279.76	279.05	279.05	10068993.0
2019-03-05 16:00:00	SPY	ETF	279.05	279.28	278.97	279.17	6995809.0
2019-03-05 16:30:00	SPY	ETF	279.18	279.2	278.93	278.95	84551.0
2019-03-05 17:00:00	SPY	ETF	279.01	279.03	278.78	278.8	151115.0
2019-03-05 17:30:00	SPY	ETF	278.82	278.82	278.66	278.74	148785.0
2019-03-05 18:00:00	SPY	ETF	278.73	278.83	278.59	278.8	109732.0
2019-03-05 18:30:00	SPY	ETF	278.82	278.89	278.67	278.75	29662.0
2019-03-05 19:00:00	SPY	ETF	278.67	278.72	278.54	278.64	32237.0
2019-03-05 19:30:00	SPY	ETF	278.6	278.62	278.51	278.61	45575.0
2019-03-05 04:00:00	QQQ	ETF	174.45	174.71	174.45	174.71	1700.0
2019-03-05 04:30:00	QQQ	ETF	174.78	174.78	174.68	174.68	445.0
2019-03-05 05:00:00	QQQ	ETF	174.65	174.65	174.62	174.62	300.0
2019-03-05 05:30:00	QQQ	ETF	174.56	174.57	174.42	174.52	13650.0
2019-03-05 06:00:00	QQQ	ETF	174.47	174.47	174.35	174.42	10450.0
2019-03-05 06:30:00	QQQ	ETF	174.42	174.49	174.42	174.46	4500.0
2019-03-05 07:00:00	QQQ	ETF	174.48	174.48	174.11	174.21	143164.0
2019-03-05 07:30:00	QQQ	ETF	174.24	174.27	174.05	174.14	128614.0
2019-03-05 08:00:00	QQQ	ETF	174.47	174.47	174.18	174.42	214553.0
2019-03-05 08:30:00	QQQ	ETF	174.4	174.61	174.36	174.36	136572.0
2019-03-05 09:00:00	QQQ	ETF	174.3	174.54	174.27	174.51	74600.0
2019-03-05 09:30:00	QQQ	ETF	174.52	174.6199	173.685	174.0	3310687.0
2019-03-05 10:00:00	QQQ	ETF	174.01	174.5805	173.94	174.14	2352350.0
2019-03-05 10:30:00	QQQ	ETF	174.14	174.7	174.1388	174.455	1366902.0
2019-03-05 11:00:00	QQQ	ETF	174.475	174.75	174.31	174.63	1127244.0
2019-03-05 11:30:00	QQQ	ETF	174.64	174.98	174.5	174.69	1389826.0
2019-03-05 12:00:00	QQQ	ETF	174.69	174.8	174.5	174.585	662979.0
2019-03-05 12:30:00	QQQ	ETF	174.585	174.67	174.445	174.6234	510004.0

> showing 50 of 17,013 rows — these rows as CSV

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