PREVIEW / etf_30min / 2021-10-06

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-06.parquet
  size:    630 KB
  rows:    24,473

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
2021-10-06 04:00:00	SPY	ETF	428.92	431.91	428.18	429.05	61599.0
2021-10-06 04:30:00	SPY	ETF	429.17	429.22	428.2	428.39	23418.0
2021-10-06 05:00:00	SPY	ETF	428.2	428.2	427.25	427.32	48676.0
2021-10-06 05:30:00	SPY	ETF	427.27	427.87	426.95	427.68	216385.0
2021-10-06 06:00:00	SPY	ETF	427.48	428.14	427.37	427.95	109562.0
2021-10-06 06:30:00	SPY	ETF	427.92	427.93	427.36	427.74	185010.0
2021-10-06 07:00:00	SPY	ETF	427.8	428.38	427.68	428.33	398033.0
2021-10-06 07:30:00	SPY	ETF	428.32	428.7	427.71	428.58	389110.0
2021-10-06 08:00:00	SPY	ETF	427.8301	433.494	427.4496	429.4	695062.0
2021-10-06 08:30:00	SPY	ETF	429.39	429.64	428.75	428.87	441789.0
2021-10-06 09:00:00	SPY	ETF	428.88	429.86	428.81	429.3	429980.0
2021-10-06 09:30:00	SPY	ETF	429.27	431.32	428.65	428.87	10678341.0
2021-10-06 10:00:00	SPY	ETF	428.87	431.11	427.54	430.562	10932110.0
2021-10-06 10:30:00	SPY	ETF	430.54	431.52	429.7	430.95	6799446.0
2021-10-06 11:00:00	SPY	ETF	430.95	431.43	429.44	429.57	4971300.0
2021-10-06 11:30:00	SPY	ETF	429.58	431.21	429.08	431.075	4124527.0
2021-10-06 12:00:00	SPY	ETF	431.07	431.19	429.11	429.58	4327492.0
2021-10-06 12:30:00	SPY	ETF	429.57	430.55	429.35	430.01	2904364.0
2021-10-06 13:00:00	SPY	ETF	430.0	431.27	429.19	431.26	4492003.0
2021-10-06 13:30:00	SPY	ETF	431.25	432.81	431.19	432.56	6194760.0
2021-10-06 14:00:00	SPY	ETF	432.57	434.21	432.02	433.99	7798304.0
2021-10-06 14:30:00	SPY	ETF	433.98	434.53	433.22	433.28	5692215.0
2021-10-06 15:00:00	SPY	ETF	433.28	433.975	433.15	433.95	5381404.0
2021-10-06 15:30:00	SPY	ETF	433.94	435.1199	433.03	434.91	10924998.0
2021-10-06 16:00:00	SPY	ETF	434.91	435.25	434.57	435.12	2820256.0
2021-10-06 16:30:00	SPY	ETF	435.15	435.29	435.03	435.07	170283.0
2021-10-06 17:00:00	SPY	ETF	435.07	435.07	434.9	434.98	168894.0
2021-10-06 17:30:00	SPY	ETF	434.99	435.2	434.97	435.19	40975.0
2021-10-06 18:00:00	SPY	ETF	435.15	435.84	435.15	435.63	82412.0
2021-10-06 18:30:00	SPY	ETF	434.9	436.24	434.9	436.12	105636.0
2021-10-06 19:00:00	SPY	ETF	436.15	436.67	436.06	436.13	63228.0
2021-10-06 19:30:00	SPY	ETF	436.15	436.27	435.8	436.12	157162.0
2021-10-06 04:00:00	QQQ	ETF	356.28	356.28	352.72	353.47	90675.0
2021-10-06 04:30:00	QQQ	ETF	353.48	353.55	352.61	352.72	87608.0
2021-10-06 05:00:00	QQQ	ETF	352.58	352.74	351.75	351.9	108053.0
2021-10-06 05:30:00	QQQ	ETF	351.83	352.34	351.68	352.26	172030.0
2021-10-06 06:00:00	QQQ	ETF	352.26	352.7	351.97	352.37	123922.0
2021-10-06 06:30:00	QQQ	ETF	352.34	352.48	351.84	352.31	132978.0
2021-10-06 07:00:00	QQQ	ETF	352.32	353.0	352.23	352.86	322507.0
2021-10-06 07:30:00	QQQ	ETF	352.85	353.4	352.49	353.3	215569.0
2021-10-06 08:00:00	QQQ	ETF	353.27	357.648	351.8796	353.76	384197.0
2021-10-06 08:30:00	QQQ	ETF	353.76	354.18	353.49	353.75	455265.0
2021-10-06 09:00:00	QQQ	ETF	353.75	354.6	353.72	354.12	445280.0
2021-10-06 09:30:00	QQQ	ETF	354.07	356.93	353.83	354.47	7518795.0
2021-10-06 10:00:00	QQQ	ETF	354.45	357.63	353.15	357.08	6656330.0
2021-10-06 10:30:00	QQQ	ETF	357.08	358.12	356.56	357.4001	3780971.0
2021-10-06 11:00:00	QQQ	ETF	357.39	357.74	355.54	355.9499	2788163.0
2021-10-06 11:30:00	QQQ	ETF	355.96	357.51	355.63	357.4101	2262482.0
2021-10-06 12:00:00	QQQ	ETF	357.41	357.46	355.45	355.83	2022859.0
2021-10-06 12:30:00	QQQ	ETF	355.82	356.62	355.46	356.01	1577351.0

> showing 50 of 24,473 rows — these rows as CSV

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