PREVIEW / etf_30min / 2022-06-27

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-27.parquet
  size:    657 KB
  rows:    26,455

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-27 04:00:00	SPY	ETF	392.57	392.94	391.02	392.57	40538.0
2022-06-27 04:30:00	SPY	ETF	392.67	392.68	391.6	391.71	24660.0
2022-06-27 05:00:00	SPY	ETF	391.74	391.9	391.35	391.9	18704.0
2022-06-27 05:30:00	SPY	ETF	391.85	391.99	391.5	391.7	30780.0
2022-06-27 06:00:00	SPY	ETF	391.67	391.67	390.87	390.87	18510.0
2022-06-27 06:30:00	SPY	ETF	391.02	391.21	390.68	391.2	24650.0
2022-06-27 07:00:00	SPY	ETF	391.19	391.71	391.1	391.33	87153.0
2022-06-27 07:30:00	SPY	ETF	391.33	391.76	391.3	391.43	129623.0
2022-06-27 08:00:00	SPY	ETF	391.19	392.7196	389.71	390.63	211948.0
2022-06-27 08:30:00	SPY	ETF	390.71	390.75	390.03	390.37	280309.0
2022-06-27 09:00:00	SPY	ETF	390.39	391.2	390.38	391.05	273566.0
2022-06-27 09:30:00	SPY	ETF	391.05	391.36	387.52	388.1	7754865.0
2022-06-27 10:00:00	SPY	ETF	388.13	389.87	387.99	388.19	4553120.0
2022-06-27 10:30:00	SPY	ETF	388.19	390.86	388.09	390.382	3778624.0
2022-06-27 11:00:00	SPY	ETF	390.36	391.12	389.39	390.89	2924136.0
2022-06-27 11:30:00	SPY	ETF	390.905	391.13	390.01	390.58	2544396.0
2022-06-27 12:00:00	SPY	ETF	390.6	390.745	388.97	389.14	2418148.0
2022-06-27 12:30:00	SPY	ETF	389.16	389.965	388.55	389.82	2241059.0
2022-06-27 13:00:00	SPY	ETF	389.82	389.94	388.64	389.22	2506419.0
2022-06-27 13:30:00	SPY	ETF	389.22	389.2699	388.1	388.3918	2288939.0
2022-06-27 14:00:00	SPY	ETF	388.42	389.18	387.96	388.6	2629805.0
2022-06-27 14:30:00	SPY	ETF	388.58	389.37	388.34	388.58	2287809.0
2022-06-27 15:00:00	SPY	ETF	388.59	389.195	387.46	388.82	3776171.0
2022-06-27 15:30:00	SPY	ETF	388.82	389.2099	387.44	388.66	7635622.0
2022-06-27 16:00:00	SPY	ETF	388.66	389.33	388.5307	389.05	3317790.0
2022-06-27 16:30:00	SPY	ETF	389.09	389.23	388.53	389.15	261968.0
2022-06-27 17:00:00	SPY	ETF	389.27	389.35	389.16	389.26	25277.0
2022-06-27 17:30:00	SPY	ETF	389.26	389.26	388.96	389.15	78927.0
2022-06-27 18:00:00	SPY	ETF	389.15	389.35	388.74	388.81	47587.0
2022-06-27 18:30:00	SPY	ETF	388.82	389.05	388.81	389.01	6596.0
2022-06-27 19:00:00	SPY	ETF	388.95	389.25	388.95	389.2	7303.0
2022-06-27 19:30:00	SPY	ETF	389.2	389.2	388.91	389.09	35154.0
2022-06-27 04:00:00	QQQ	ETF	296.56	297.8	295.66	297.6	89224.0
2022-06-27 04:30:00	QQQ	ETF	297.58	297.64	296.62	296.81	51680.0
2022-06-27 05:00:00	QQQ	ETF	296.75	296.88	296.32	296.84	30812.0
2022-06-27 05:30:00	QQQ	ETF	296.75	296.96	296.64	296.79	28184.0
2022-06-27 06:00:00	QQQ	ETF	296.79	296.8	296.1	296.13	34145.0
2022-06-27 06:30:00	QQQ	ETF	296.08	296.31	295.85	296.2	165311.0
2022-06-27 07:00:00	QQQ	ETF	296.2	296.66	296.13	296.36	128718.0
2022-06-27 07:30:00	QQQ	ETF	296.38	296.78	296.38	296.43	192941.0
2022-06-27 08:00:00	QQQ	ETF	296.42	297.75	294.61	295.82	268463.0
2022-06-27 08:30:00	QQQ	ETF	295.84	295.88	295.03	295.36	353709.0
2022-06-27 09:00:00	QQQ	ETF	295.35	296.12	295.33	296.02	292309.0
2022-06-27 09:30:00	QQQ	ETF	296.0	296.5799	291.92	292.99	7110821.0
2022-06-27 10:00:00	QQQ	ETF	293.0	294.42	292.03	292.34	3791641.0
2022-06-27 10:30:00	QQQ	ETF	292.34	295.05	292.24	294.76	3055154.0
2022-06-27 11:00:00	QQQ	ETF	294.75	294.92	293.525	294.785	2052604.0
2022-06-27 11:30:00	QQQ	ETF	294.77	295.13	293.865	294.3402	1729637.0
2022-06-27 12:00:00	QQQ	ETF	294.335	294.52	292.67	292.8001	1496072.0
2022-06-27 12:30:00	QQQ	ETF	292.805	293.75	292.41	293.71	1398181.0

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

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