PREVIEW / etf_30min / 2020-05-01

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-01.parquet
  size:    570 KB
  rows:    20,921

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
2020-05-01 04:00:00	SPY	ETF	284.39	284.9	283.68	284.85	60591.0
2020-05-01 04:30:00	SPY	ETF	284.8	285.33	284.55	285.18	90362.0
2020-05-01 05:00:00	SPY	ETF	285.24	285.31	284.58	284.82	36332.0
2020-05-01 05:30:00	SPY	ETF	284.87	284.87	284.39	284.78	6895.0
2020-05-01 06:00:00	SPY	ETF	284.64	285.36	284.64	285.16	83317.0
2020-05-01 06:30:00	SPY	ETF	285.09	285.26	284.63	284.96	108947.0
2020-05-01 07:00:00	SPY	ETF	284.97	285.02	284.03	284.25	185890.0
2020-05-01 07:30:00	SPY	ETF	284.09	285.01	283.97	284.78	358499.0
2020-05-01 08:00:00	SPY	ETF	284.79	286.88	283.79	284.56	383694.0
2020-05-01 08:30:00	SPY	ETF	284.55	284.86	284.26	284.66	309657.0
2020-05-01 09:00:00	SPY	ETF	284.51	285.7	284.4	285.31	1013791.0
2020-05-01 09:30:00	SPY	ETF	285.31	286.04	284.42	285.07	14265045.0
2020-05-01 10:00:00	SPY	ETF	285.08	285.96	284.16	285.08	13331074.0
2020-05-01 10:30:00	SPY	ETF	285.08	285.7	284.58	285.08	6767182.0
2020-05-01 11:00:00	SPY	ETF	285.07	285.09	283.87	283.88	8267417.0
2020-05-01 11:30:00	SPY	ETF	283.88	283.96	282.41	282.72	9009438.0
2020-05-01 12:00:00	SPY	ETF	282.72	283.02	281.96	282.3201	8195919.0
2020-05-01 12:30:00	SPY	ETF	282.33	282.7	281.61	282.31	5192501.0
2020-05-01 13:00:00	SPY	ETF	282.3	282.77	281.57	282.14	4542324.0
2020-05-01 13:30:00	SPY	ETF	282.1473	282.44	281.52	281.95	4433775.0
2020-05-01 14:00:00	SPY	ETF	281.96	290.6572	281.57	282.729	6834200.0
2020-05-01 14:30:00	SPY	ETF	282.715	282.74	282.03	282.5473	3952708.0
2020-05-01 15:00:00	SPY	ETF	282.56	283.4	282.25	282.715	6247315.0
2020-05-01 15:30:00	SPY	ETF	282.715	282.94	281.63	282.73	20282138.0
2020-05-01 16:00:00	SPY	ETF	282.78	283.06	282.101	282.4	8022767.0
2020-05-01 16:30:00	SPY	ETF	282.43	282.79	281.96	282.09	477115.0
2020-05-01 17:00:00	SPY	ETF	282.03	282.79	282.03	282.46	115933.0
2020-05-01 17:30:00	SPY	ETF	282.5	282.86	282.5	282.72	84049.0
2020-05-01 18:00:00	SPY	ETF	282.7	283.0	282.61	282.97	54994.0
2020-05-01 18:30:00	SPY	ETF	282.98	283.0	282.8	282.8699	15062.0
2020-05-01 19:00:00	SPY	ETF	282.85	282.94	282.77	282.83	20543.0
2020-05-01 19:30:00	SPY	ETF	282.83	282.91	282.79	282.9	34731.0
2020-05-01 04:00:00	QQQ	ETF	213.67	213.95	213.19	213.95	37003.0
2020-05-01 04:30:00	QQQ	ETF	213.88	214.05	213.65	214.05	24408.0
2020-05-01 05:00:00	QQQ	ETF	214.05	214.11	213.68	213.87	18624.0
2020-05-01 05:30:00	QQQ	ETF	213.85	213.95	213.64	213.88	17240.0
2020-05-01 06:00:00	QQQ	ETF	213.81	214.42	213.81	214.28	25750.0
2020-05-01 06:30:00	QQQ	ETF	214.25	214.36	213.82	214.05	41419.0
2020-05-01 07:00:00	QQQ	ETF	214.05	214.12	213.5	213.57	84207.0
2020-05-01 07:30:00	QQQ	ETF	213.48	214.39	213.41	214.32	99008.0
2020-05-01 08:00:00	QQQ	ETF	214.3	215.56	213.46	214.04	228074.0
2020-05-01 08:30:00	QQQ	ETF	214.03	214.43	214.03	214.38	150135.0
2020-05-01 09:00:00	QQQ	ETF	214.3	215.08	214.17	214.53	385150.0
2020-05-01 09:30:00	QQQ	ETF	214.52	215.79	214.27	215.46	5587270.0
2020-05-01 10:00:00	QQQ	ETF	215.48	216.67	215.01	215.51	4370583.0
2020-05-01 10:30:00	QQQ	ETF	215.5	215.92	214.95	215.48	2282332.0
2020-05-01 11:00:00	QQQ	ETF	215.425	215.46	214.35	214.38	2166862.0
2020-05-01 11:30:00	QQQ	ETF	214.37	214.41	212.92	213.1223	2512732.0
2020-05-01 12:00:00	QQQ	ETF	213.125	213.21	212.16	212.51	2813495.0
2020-05-01 12:30:00	QQQ	ETF	212.51	212.8399	211.765	212.345	3066040.0

> showing 50 of 20,921 rows — these rows as CSV

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