PREVIEW / etf_30min / 2020-11-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-20.parquet
  size:    574 KB
  rows:    20,992

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-11-20 04:00:00	SPY	ETF	356.68	357.39	356.47	357.34	41464.0
2020-11-20 04:30:00	SPY	ETF	357.25	357.57	357.13	357.22	18452.0
2020-11-20 05:00:00	SPY	ETF	357.2	357.67	357.11	357.65	22581.0
2020-11-20 05:30:00	SPY	ETF	357.59	357.92	357.42	357.54	24813.0
2020-11-20 06:00:00	SPY	ETF	357.5	357.66	357.38	357.38	9654.0
2020-11-20 06:30:00	SPY	ETF	357.47	358.0	357.47	357.97	20650.0
2020-11-20 07:00:00	SPY	ETF	358.08	358.19	357.75	357.88	205534.0
2020-11-20 07:30:00	SPY	ETF	357.86	357.91	357.49	357.63	62229.0
2020-11-20 08:00:00	SPY	ETF	357.64	358.1601	356.1	357.47	170231.0
2020-11-20 08:30:00	SPY	ETF	357.56	357.56	357.03	357.05	96425.0
2020-11-20 09:00:00	SPY	ETF	357.05	357.8	356.94	357.48	514166.0
2020-11-20 09:30:00	SPY	ETF	357.5	357.72	356.54	357.04	5482136.0
2020-11-20 10:00:00	SPY	ETF	357.039	357.2	356.18	356.8	5830284.0
2020-11-20 10:30:00	SPY	ETF	356.8	357.17	356.28	356.86	5148418.0
2020-11-20 11:00:00	SPY	ETF	356.87	357.48	356.81	357.32	3186297.0
2020-11-20 11:30:00	SPY	ETF	357.32	357.56	356.44	356.88	3162317.0
2020-11-20 12:00:00	SPY	ETF	356.87	357.02	356.621	356.91	1442125.0
2020-11-20 12:30:00	SPY	ETF	356.915	356.99	356.55	356.91	1473081.0
2020-11-20 13:00:00	SPY	ETF	356.9	357.27	356.6	357.21	1435088.0
2020-11-20 13:30:00	SPY	ETF	357.22	357.33	357.02	357.16	3365506.0
2020-11-20 14:00:00	SPY	ETF	357.17	357.22	356.76	357.08	1652591.0
2020-11-20 14:30:00	SPY	ETF	357.075	357.44	356.67	356.84	2099055.0
2020-11-20 15:00:00	SPY	ETF	356.86	356.97	355.57	355.99	4186013.0
2020-11-20 15:30:00	SPY	ETF	355.985	357.065	355.25	355.35	11046460.0
2020-11-20 16:00:00	SPY	ETF	355.34	357.8193	354.25	354.66	15258017.0
2020-11-20 16:30:00	SPY	ETF	354.58	357.8193	354.43	355.17	3010130.0
2020-11-20 17:00:00	SPY	ETF	355.22	355.45	354.92	354.98	379556.0
2020-11-20 17:30:00	SPY	ETF	354.97	354.98	354.75	354.85	147573.0
2020-11-20 18:00:00	SPY	ETF	354.8	355.33	354.76	354.92	26669.0
2020-11-20 18:30:00	SPY	ETF	354.95	354.98	354.83	354.9	5627.0
2020-11-20 19:00:00	SPY	ETF	354.92	354.98	354.86	354.87	10288.0
2020-11-20 19:30:00	SPY	ETF	354.87	355.26	354.8	355.0	29209.0
2020-11-20 04:00:00	QQQ	ETF	292.35	292.53	291.98	292.5	25872.0
2020-11-20 04:30:00	QQQ	ETF	292.59	292.62	292.39	292.48	5983.0
2020-11-20 05:00:00	QQQ	ETF	292.43	292.49	292.25	292.48	13440.0
2020-11-20 05:30:00	QQQ	ETF	292.41	292.8	292.31	292.8	17018.0
2020-11-20 06:00:00	QQQ	ETF	292.73	292.9	292.64	292.66	10382.0
2020-11-20 06:30:00	QQQ	ETF	292.84	292.85	292.67	292.85	6015.0
2020-11-20 07:00:00	QQQ	ETF	292.9	293.16	292.82	292.93	80179.0
2020-11-20 07:30:00	QQQ	ETF	292.85	292.94	292.79	292.82	27060.0
2020-11-20 08:00:00	QQQ	ETF	293.0599	293.08	291.92	292.53	71888.0
2020-11-20 08:30:00	QQQ	ETF	292.56	292.59	292.35	292.43	64010.0
2020-11-20 09:00:00	QQQ	ETF	292.39	292.56	292.26	292.35	166847.0
2020-11-20 09:30:00	QQQ	ETF	292.3	292.31	291.37	291.8401	2040070.0
2020-11-20 10:00:00	QQQ	ETF	291.859	292.44	291.65	292.3779	1223615.0
2020-11-20 10:30:00	QQQ	ETF	292.38	292.9	292.16	292.57	1107837.0
2020-11-20 11:00:00	QQQ	ETF	292.59	293.065	292.5492	292.71	816779.0
2020-11-20 11:30:00	QQQ	ETF	292.71	292.82	291.89	292.119	1403545.0
2020-11-20 12:00:00	QQQ	ETF	292.1	292.57	291.93	292.55	543612.0
2020-11-20 12:30:00	QQQ	ETF	292.53	292.65	292.17	292.4741	410160.0

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

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