PREVIEW / etf_30min / 2022-12-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-22.parquet
  size:    724 KB
  rows:    28,236

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-12-22 04:00:00	SPY	ETF	386.97	387.14	386.57	386.67	40696.0
2022-12-22 04:30:00	SPY	ETF	386.69	387.14	386.4	386.41	17754.0
2022-12-22 05:00:00	SPY	ETF	386.41	386.41	385.98	386.2	15550.0
2022-12-22 05:30:00	SPY	ETF	386.12	386.28	385.94	386.07	12297.0
2022-12-22 06:00:00	SPY	ETF	385.99	386.0	385.31	385.36	35461.0
2022-12-22 06:30:00	SPY	ETF	385.5	385.8	385.41	385.76	33793.0
2022-12-22 07:00:00	SPY	ETF	385.72	386.0	385.03	385.37	108928.0
2022-12-22 07:30:00	SPY	ETF	385.39	385.45	385.1	385.38	91794.0
2022-12-22 08:00:00	SPY	ETF	385.38	387.49	385.0	385.01	285374.0
2022-12-22 08:30:00	SPY	ETF	385.07	385.07	382.84	383.17	614977.0
2022-12-22 09:00:00	SPY	ETF	383.08	383.34	382.89	383.05	411502.0
2022-12-22 09:30:00	SPY	ETF	383.05	383.38	380.97	381.585	5578886.0
2022-12-22 10:00:00	SPY	ETF	381.57	381.57	379.36	379.496	6006261.0
2022-12-22 10:30:00	SPY	ETF	379.485	379.81	378.92	379.0999	4648213.0
2022-12-22 11:00:00	SPY	ETF	379.1	379.61	378.66	379.15	2664484.0
2022-12-22 11:30:00	SPY	ETF	379.16	379.3394	378.22	378.68	2754329.0
2022-12-22 12:00:00	SPY	ETF	378.69	378.74	376.529	376.72	3512132.0
2022-12-22 12:30:00	SPY	ETF	376.72	376.94	376.11	376.55	3672228.0
2022-12-22 13:00:00	SPY	ETF	376.55	376.55	375.22	375.49	3897743.0
2022-12-22 13:30:00	SPY	ETF	375.49	375.89	374.77	375.53	4207036.0
2022-12-22 14:00:00	SPY	ETF	375.52	377.34	375.5	377.21	4669061.0
2022-12-22 14:30:00	SPY	ETF	377.22	378.62	376.75	378.491	4743207.0
2022-12-22 15:00:00	SPY	ETF	378.4901	380.39	378.19	380.2799	6951814.0
2022-12-22 15:30:00	SPY	ETF	380.27	380.82	378.935	380.76	13278143.0
2022-12-22 16:00:00	SPY	ETF	380.75	381.44	379.846	380.2	4168228.0
2022-12-22 16:30:00	SPY	ETF	380.21	380.72	380.21	380.54	381884.0
2022-12-22 17:00:00	SPY	ETF	380.54	380.7	380.42	380.64	26500.0
2022-12-22 17:30:00	SPY	ETF	380.68	380.9	380.68	380.9	38506.0
2022-12-22 18:00:00	SPY	ETF	380.75	380.78	380.33	380.42	42693.0
2022-12-22 18:30:00	SPY	ETF	380.56	380.75	380.45	380.62	45405.0
2022-12-22 19:00:00	SPY	ETF	380.61	380.75	380.25	380.26	32283.0
2022-12-22 19:30:00	SPY	ETF	380.24	380.42	379.7	379.71	94472.0
2022-12-22 04:00:00	QQQ	ETF	274.32	274.32	273.73	273.86	40694.0
2022-12-22 04:30:00	QQQ	ETF	273.82	274.25	273.7	273.7	15597.0
2022-12-22 05:00:00	QQQ	ETF	273.65	273.65	273.35	273.46	19363.0
2022-12-22 05:30:00	QQQ	ETF	273.37	273.5	273.24	273.39	39419.0
2022-12-22 06:00:00	QQQ	ETF	273.41	273.42	272.8	272.89	34664.0
2022-12-22 06:30:00	QQQ	ETF	272.95	273.2	272.95	273.2	12441.0
2022-12-22 07:00:00	QQQ	ETF	273.16	273.37	272.43	272.7	85349.0
2022-12-22 07:30:00	QQQ	ETF	272.67	272.72	272.27	272.59	74853.0
2022-12-22 08:00:00	QQQ	ETF	273.28	274.61	272.24	272.38	235269.0
2022-12-22 08:30:00	QQQ	ETF	272.3	272.3	270.14	270.41	609779.0
2022-12-22 09:00:00	QQQ	ETF	270.37	270.45	270.015	270.37	644252.0
2022-12-22 09:30:00	QQQ	ETF	270.38	270.5149	267.7701	268.53	4523975.0
2022-12-22 10:00:00	QQQ	ETF	268.53	268.53	266.12	266.17	3836921.0
2022-12-22 10:30:00	QQQ	ETF	266.16	266.3596	265.51	265.715	3100398.0
2022-12-22 11:00:00	QQQ	ETF	265.72	266.31	265.34	265.65	1804146.0
2022-12-22 11:30:00	QQQ	ETF	265.64	265.78	264.67	265.1	2136646.0
2022-12-22 12:00:00	QQQ	ETF	265.1	265.17	263.57	263.76	2304758.0
2022-12-22 12:30:00	QQQ	ETF	263.74	263.9269	263.3	263.8301	2701914.0

> showing 50 of 28,236 rows — these rows as CSV

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