PREVIEW / etf_30min / 2022-09-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-16.parquet
  size:    664 KB
  rows:    26,951

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
2022-09-16 04:00:00	SPY	ETF	385.5	386.5	384.83	384.83	55211.0
2022-09-16 04:30:00	SPY	ETF	384.9	384.92	384.55	384.9	27420.0
2022-09-16 05:00:00	SPY	ETF	384.82	385.29	384.81	385.01	17967.0
2022-09-16 05:30:00	SPY	ETF	384.95	385.05	384.67	385.04	14740.0
2022-09-16 06:00:00	SPY	ETF	384.91	385.2	384.64	385.09	37088.0
2022-09-16 06:30:00	SPY	ETF	385.14	386.1	385.12	385.94	77866.0
2022-09-16 07:00:00	SPY	ETF	386.04	386.05	385.2	385.55	185038.0
2022-09-16 07:30:00	SPY	ETF	385.5	385.8	385.17	385.45	151292.0
2022-09-16 08:00:00	SPY	ETF	385.8801	386.42	384.45	384.59	425856.0
2022-09-16 08:30:00	SPY	ETF	384.54	384.54	383.14	383.25	510025.0
2022-09-16 09:00:00	SPY	ETF	383.25	384.21	383.08	384.15	857021.0
2022-09-16 09:30:00	SPY	ETF	384.14	384.68	382.12	382.6099	10408914.0
2022-09-16 10:00:00	SPY	ETF	382.54	385.29	382.52	384.29	7137636.0
2022-09-16 10:30:00	SPY	ETF	384.29	385.89	383.5	383.5	5087782.0
2022-09-16 11:00:00	SPY	ETF	383.55	384.68	383.35	383.47	3118832.0
2022-09-16 11:30:00	SPY	ETF	383.46	384.3926	382.85	384.286	2970802.0
2022-09-16 12:00:00	SPY	ETF	384.27	384.36	382.11	382.36	2704505.0
2022-09-16 12:30:00	SPY	ETF	382.37	383.62	382.22	383.52	2594872.0
2022-09-16 13:00:00	SPY	ETF	383.49	383.69	382.6799	382.96	2590719.0
2022-09-16 13:30:00	SPY	ETF	382.94	383.87	382.455	382.795	2968994.0
2022-09-16 14:00:00	SPY	ETF	382.81	384.61	382.665	384.31	3364867.0
2022-09-16 14:30:00	SPY	ETF	384.33	385.23	383.7	384.87	4134831.0
2022-09-16 15:00:00	SPY	ETF	384.86	386.165	384.6	384.93	5311675.0
2022-09-16 15:30:00	SPY	ETF	384.92	386.25	384.16	385.64	10335283.0
2022-09-16 16:00:00	SPY	ETF	385.64	386.39	385.45	386.12	4834066.0
2022-09-16 16:30:00	SPY	ETF	386.08	387.0	385.56	386.91	658092.0
2022-09-16 17:00:00	SPY	ETF	386.87	386.99	385.56	386.98	361148.0
2022-09-16 17:30:00	SPY	ETF	386.98	387.14	385.56	387.1	104791.0
2022-09-16 18:00:00	SPY	ETF	387.1	387.2	387.02	387.2	47408.0
2022-09-16 18:30:00	SPY	ETF	387.18	388.0	387.08	387.12	169977.0
2022-09-16 19:00:00	SPY	ETF	387.13	387.13	387.04	387.1	11293.0
2022-09-16 19:30:00	SPY	ETF	387.1	387.45	387.0	387.4	39522.0
2022-09-16 04:00:00	QQQ	ETF	288.37	288.5	287.62	287.7	131028.0
2022-09-16 04:30:00	QQQ	ETF	287.73	287.82	287.41	287.82	37060.0
2022-09-16 05:00:00	QQQ	ETF	287.68	288.02	287.68	287.78	39531.0
2022-09-16 05:30:00	QQQ	ETF	287.82	288.13	287.6	287.78	35597.0
2022-09-16 06:00:00	QQQ	ETF	287.8	288.02	287.52	287.95	52530.0
2022-09-16 06:30:00	QQQ	ETF	287.97	288.96	287.95	288.85	77814.0
2022-09-16 07:00:00	QQQ	ETF	288.86	288.86	287.98	288.31	111529.0
2022-09-16 07:30:00	QQQ	ETF	288.25	288.64	287.99	288.37	125589.0
2022-09-16 08:00:00	QQQ	ETF	288.65	291.318	287.4496	287.69	395902.0
2022-09-16 08:30:00	QQQ	ETF	287.67	287.9	286.92	287.03	500443.0
2022-09-16 09:00:00	QQQ	ETF	287.05	287.8	286.71	287.76	896008.0
2022-09-16 09:30:00	QQQ	ETF	287.72	287.78	285.64	285.99	7820619.0
2022-09-16 10:00:00	QQQ	ETF	285.99	288.28	285.93	287.2	6289200.0
2022-09-16 10:30:00	QQQ	ETF	287.29	288.89	286.45	286.48	4477323.0
2022-09-16 11:00:00	QQQ	ETF	286.495	287.51	286.2405	286.54	2370642.0
2022-09-16 11:30:00	QQQ	ETF	286.53	287.72	286.0	287.578	2217392.0
2022-09-16 12:00:00	QQQ	ETF	287.58	287.6701	285.62	285.89	2347880.0
2022-09-16 12:30:00	QQQ	ETF	285.86	287.24	285.8	287.17	2219862.0

> showing 50 of 26,951 rows — these rows as CSV

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