PREVIEW / etf_30min / 2021-12-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-14.parquet
  size:    659 KB
  rows:    25,247

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-12-14 04:00:00	SPY	ETF	467.48	467.9	467.45	467.45	17017.0
2021-12-14 04:30:00	SPY	ETF	467.43	467.6	464.9	464.9	61706.0
2021-12-14 05:00:00	SPY	ETF	464.89	465.27	464.75	465.2	38081.0
2021-12-14 05:30:00	SPY	ETF	465.5	465.5	464.95	465.27	13558.0
2021-12-14 06:00:00	SPY	ETF	465.3	465.83	465.3	465.38	23705.0
2021-12-14 06:30:00	SPY	ETF	465.45	465.77	465.21	465.35	59980.0
2021-12-14 07:00:00	SPY	ETF	465.44	466.17	465.39	466.13	78406.0
2021-12-14 07:30:00	SPY	ETF	466.13	466.15	465.49	465.61	73071.0
2021-12-14 08:00:00	SPY	ETF	465.9501	468.0	465.0796	465.44	129424.0
2021-12-14 08:30:00	SPY	ETF	465.5	467.31	463.48	463.75	781938.0
2021-12-14 09:00:00	SPY	ETF	463.75	466.57	462.97	463.05	638457.0
2021-12-14 09:30:00	SPY	ETF	463.05	465.74	462.92	464.48	7665075.0
2021-12-14 10:00:00	SPY	ETF	464.49	464.76	463.1154	464.26	4355101.0
2021-12-14 10:30:00	SPY	ETF	464.26	464.34	461.15	461.67	4922663.0
2021-12-14 11:00:00	SPY	ETF	461.65	462.16	461.065	462.05	4533856.0
2021-12-14 11:30:00	SPY	ETF	462.07	462.15	460.6999	461.02	4250359.0
2021-12-14 12:00:00	SPY	ETF	461.03	461.25	460.39	461.19	3358847.0
2021-12-14 12:30:00	SPY	ETF	461.2	461.2899	460.25	460.66	2615469.0
2021-12-14 13:00:00	SPY	ETF	460.63	461.48	460.47	461.37	2750590.0
2021-12-14 13:30:00	SPY	ETF	461.3515	461.4	460.44	460.66	1928922.0
2021-12-14 14:00:00	SPY	ETF	460.67	462.3317	460.53	461.9	4319030.0
2021-12-14 14:30:00	SPY	ETF	461.9	462.665	461.7717	462.48	2838037.0
2021-12-14 15:00:00	SPY	ETF	462.46	463.98	462.36	463.93	3736293.0
2021-12-14 15:30:00	SPY	ETF	463.94	464.44	462.37	463.39	11784946.0
2021-12-14 16:00:00	SPY	ETF	463.38	463.44	462.94	463.19	4202236.0
2021-12-14 16:30:00	SPY	ETF	463.24	463.47	463.21	463.45	169219.0
2021-12-14 17:00:00	SPY	ETF	463.43	463.43	463.25	463.27	47306.0
2021-12-14 17:30:00	SPY	ETF	463.32	463.37	463.2	463.31	23280.0
2021-12-14 18:00:00	SPY	ETF	463.36	463.68	463.05	463.06	54542.0
2021-12-14 18:30:00	SPY	ETF	463.36	463.36	462.92	463.25	31728.0
2021-12-14 19:00:00	SPY	ETF	463.28	463.79	463.2	463.75	24361.0
2021-12-14 19:30:00	SPY	ETF	463.78	463.89	463.66	463.71	31768.0
2021-12-14 04:00:00	QQQ	ETF	392.74	393.01	392.33	392.37	40733.0
2021-12-14 04:30:00	QQQ	ETF	392.29	392.38	389.44	389.53	170633.0
2021-12-14 05:00:00	QQQ	ETF	389.26	389.89	389.19	389.83	80339.0
2021-12-14 05:30:00	QQQ	ETF	389.85	390.11	389.42	389.75	26807.0
2021-12-14 06:00:00	QQQ	ETF	389.86	390.21	389.86	389.88	36905.0
2021-12-14 06:30:00	QQQ	ETF	390.0	390.1	389.48	389.6	41669.0
2021-12-14 07:00:00	QQQ	ETF	389.66	390.75	389.63	390.68	158732.0
2021-12-14 07:30:00	QQQ	ETF	390.69	390.7	390.02	390.2	140259.0
2021-12-14 08:00:00	QQQ	ETF	390.3199	392.92	389.3896	390.0	212525.0
2021-12-14 08:30:00	QQQ	ETF	390.0	390.11	387.5	388.01	994853.0
2021-12-14 09:00:00	QQQ	ETF	387.91	388.28	387.23	387.23	927427.0
2021-12-14 09:30:00	QQQ	ETF	387.3	390.09	386.65	388.3	7743479.0
2021-12-14 10:00:00	QQQ	ETF	388.33	388.75	386.55	388.17	5061485.0
2021-12-14 10:30:00	QQQ	ETF	388.17	388.61	384.95	385.5	4753163.0
2021-12-14 11:00:00	QQQ	ETF	385.49	385.74	382.24	385.64	4785443.0
2021-12-14 11:30:00	QQQ	ETF	385.65	385.84	384.27	384.94	3172376.0
2021-12-14 12:00:00	QQQ	ETF	384.95	385.14	383.9	384.52	2455748.0
2021-12-14 12:30:00	QQQ	ETF	384.53	384.69	383.78	384.5	1808802.0

> showing 50 of 25,247 rows — these rows as CSV

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