PREVIEW / etf_30min / 2022-06-02

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-02.parquet
  size:    669 KB
  rows:    26,277

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-06-02 04:00:00	SPY	ETF	410.64	411.76	410.03	411.76	20089.0
2022-06-02 04:30:00	SPY	ETF	411.65	411.83	411.4	411.44	6047.0
2022-06-02 05:00:00	SPY	ETF	411.05	411.91	411.05	411.87	8130.0
2022-06-02 05:30:00	SPY	ETF	411.88	411.88	411.26	411.34	12726.0
2022-06-02 06:00:00	SPY	ETF	411.38	411.61	410.88	410.88	17600.0
2022-06-02 06:30:00	SPY	ETF	411.06	412.18	411.05	412.05	99887.0
2022-06-02 07:00:00	SPY	ETF	412.04	412.1	411.5	411.92	69249.0
2022-06-02 07:30:00	SPY	ETF	411.89	412.08	411.65	411.8	88420.0
2022-06-02 08:00:00	SPY	ETF	411.6701	412.17	409.57	411.28	490589.0
2022-06-02 08:30:00	SPY	ETF	411.11	411.62	410.79	410.84	129630.0
2022-06-02 09:00:00	SPY	ETF	410.95	411.18	409.0	409.47	561391.0
2022-06-02 09:30:00	SPY	ETF	409.42	409.68	407.32	408.2	5946807.0
2022-06-02 10:00:00	SPY	ETF	408.19	410.57	407.04	407.9663	5430150.0
2022-06-02 10:30:00	SPY	ETF	407.96	409.87	407.6	409.74	3521450.0
2022-06-02 11:00:00	SPY	ETF	409.76	411.979	409.58	411.67	4859589.0
2022-06-02 11:30:00	SPY	ETF	411.69	413.3645	410.78	412.3099	3803329.0
2022-06-02 12:00:00	SPY	ETF	412.33	413.97	412.08	413.97	2679036.0
2022-06-02 12:30:00	SPY	ETF	413.97	414.67	413.725	414.3	3258272.0
2022-06-02 13:00:00	SPY	ETF	414.31	414.63	413.62	414.33	2718243.0
2022-06-02 13:30:00	SPY	ETF	414.33	415.23	414.22	415.0344	3722260.0
2022-06-02 14:00:00	SPY	ETF	415.05	415.68	414.731	415.2	3363089.0
2022-06-02 14:30:00	SPY	ETF	415.205	415.8	414.62	414.71	2912702.0
2022-06-02 15:00:00	SPY	ETF	414.7	416.075	414.57	415.34	4143481.0
2022-06-02 15:30:00	SPY	ETF	415.34	417.44	415.23	417.37	10037970.0
2022-06-02 16:00:00	SPY	ETF	417.36	418.0	416.72	417.35	4113335.0
2022-06-02 16:30:00	SPY	ETF	417.34	417.65	417.28	417.58	219158.0
2022-06-02 17:00:00	SPY	ETF	417.59	417.68	417.49	417.62	13991.0
2022-06-02 17:30:00	SPY	ETF	417.63	417.7	417.45	417.47	41409.0
2022-06-02 18:00:00	SPY	ETF	417.47	418.6	417.47	417.84	75612.0
2022-06-02 18:30:00	SPY	ETF	417.83	418.01	417.76	417.81	14946.0
2022-06-02 19:00:00	SPY	ETF	417.92	418.29	417.9	418.12	17171.0
2022-06-02 19:30:00	SPY	ETF	418.11	418.26	417.88	418.0	23852.0
2022-06-02 04:00:00	QQQ	ETF	306.52	308.34	306.52	308.18	45374.0
2022-06-02 04:30:00	QQQ	ETF	308.26	308.33	307.64	307.65	18934.0
2022-06-02 05:00:00	QQQ	ETF	307.67	308.26	307.41	308.2	15944.0
2022-06-02 05:30:00	QQQ	ETF	308.21	308.21	307.74	307.78	15575.0
2022-06-02 06:00:00	QQQ	ETF	307.76	307.91	307.39	307.39	12122.0
2022-06-02 06:30:00	QQQ	ETF	307.56	308.58	307.5	308.37	86353.0
2022-06-02 07:00:00	QQQ	ETF	308.37	308.37	307.73	308.18	52424.0
2022-06-02 07:30:00	QQQ	ETF	308.22	308.31	307.91	308.06	118900.0
2022-06-02 08:00:00	QQQ	ETF	307.87	308.5696	306.0	307.6	256897.0
2022-06-02 08:30:00	QQQ	ETF	307.44	307.72	306.89	306.96	231175.0
2022-06-02 09:00:00	QQQ	ETF	306.99	307.86	304.55	304.84	1904632.0
2022-06-02 09:30:00	QQQ	ETF	304.85	306.54	303.4001	305.64	6147123.0
2022-06-02 10:00:00	QQQ	ETF	305.63	308.05	304.79	305.4784	4472228.0
2022-06-02 10:30:00	QQQ	ETF	305.48	307.41	305.235	307.29	2797892.0
2022-06-02 11:00:00	QQQ	ETF	307.26	309.47	307.04	309.0994	3257625.0
2022-06-02 11:30:00	QQQ	ETF	309.09	310.4389	308.33	309.5	2538002.0
2022-06-02 12:00:00	QQQ	ETF	309.51	311.36	309.3	311.35	2232031.0
2022-06-02 12:30:00	QQQ	ETF	311.36	312.14	311.21	311.77	2465082.0

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

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