PREVIEW / etf_30min / 2022-08-01

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-01.parquet
  size:    667 KB
  rows:    26,364

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-08-01 04:00:00	SPY	ETF	411.19	411.42	410.89	410.91	12629.0
2022-08-01 04:30:00	SPY	ETF	410.93	410.96	410.45	410.58	4373.0
2022-08-01 05:00:00	SPY	ETF	410.66	411.0	410.66	410.91	3039.0
2022-08-01 05:30:00	SPY	ETF	410.89	411.36	410.89	411.21	5543.0
2022-08-01 06:00:00	SPY	ETF	411.16	411.43	411.11	411.21	11431.0
2022-08-01 06:30:00	SPY	ETF	411.21	411.26	411.03	411.17	16511.0
2022-08-01 07:00:00	SPY	ETF	411.16	411.61	411.16	411.51	48922.0
2022-08-01 07:30:00	SPY	ETF	411.46	412.06	411.37	411.5	69814.0
2022-08-01 08:00:00	SPY	ETF	411.5	411.985	410.42	410.62	260648.0
2022-08-01 08:30:00	SPY	ETF	410.57	410.77	409.0	409.4	512883.0
2022-08-01 09:00:00	SPY	ETF	409.4	409.55	408.7	409.17	611944.0
2022-08-01 09:30:00	SPY	ETF	409.15	411.76	408.4	411.19	6335519.0
2022-08-01 10:00:00	SPY	ETF	411.13	412.91	410.04	410.38	5844588.0
2022-08-01 10:30:00	SPY	ETF	410.41	413.41	410.3621	413.045	3530986.0
2022-08-01 11:00:00	SPY	ETF	413.05	413.3911	411.545	412.9111	2767531.0
2022-08-01 11:30:00	SPY	ETF	412.93	413.36	412.02	412.74	2385254.0
2022-08-01 12:00:00	SPY	ETF	412.7101	412.831	411.2902	412.1499	1962391.0
2022-08-01 12:30:00	SPY	ETF	412.14	412.44	411.37	411.86	1847107.0
2022-08-01 13:00:00	SPY	ETF	411.87	411.8799	410.13	410.1499	2555630.0
2022-08-01 13:30:00	SPY	ETF	410.13	410.43	409.07	410.03	3208343.0
2022-08-01 14:00:00	SPY	ETF	410.03	410.7171	409.24	410.33	3144183.0
2022-08-01 14:30:00	SPY	ETF	410.32	411.71	409.93	411.38	3177278.0
2022-08-01 15:00:00	SPY	ETF	411.39	411.85	410.55	410.74	3344028.0
2022-08-01 15:30:00	SPY	ETF	410.7133	411.58	410.445	410.71	8749458.0
2022-08-01 16:00:00	SPY	ETF	410.71	411.09	410.55	410.85	2723915.0
2022-08-01 16:30:00	SPY	ETF	410.85	411.02	410.82	411.02	123894.0
2022-08-01 17:00:00	SPY	ETF	411.02	411.02	410.64	410.65	107363.0
2022-08-01 17:30:00	SPY	ETF	410.72	410.77	410.53	410.63	133021.0
2022-08-01 18:00:00	SPY	ETF	410.63	410.83	410.27	410.32	131683.0
2022-08-01 18:30:00	SPY	ETF	410.34	410.61	410.28	410.61	32389.0
2022-08-01 19:00:00	SPY	ETF	410.57	410.9	410.0	410.37	35194.0
2022-08-01 19:30:00	SPY	ETF	410.31	410.39	410.08	410.13	41736.0
2022-08-01 04:00:00	QQQ	ETF	315.04	315.07	314.0	314.52	30630.0
2022-08-01 04:30:00	QQQ	ETF	314.55	314.62	314.05	314.23	21784.0
2022-08-01 05:00:00	QQQ	ETF	314.28	314.6	314.28	314.55	6127.0
2022-08-01 05:30:00	QQQ	ETF	314.74	314.89	314.6	314.75	12066.0
2022-08-01 06:00:00	QQQ	ETF	314.98	314.98	314.59	314.75	17452.0
2022-08-01 06:30:00	QQQ	ETF	314.74	314.81	314.65	314.76	28604.0
2022-08-01 07:00:00	QQQ	ETF	314.85	315.32	314.85	315.25	56684.0
2022-08-01 07:30:00	QQQ	ETF	315.23	315.88	315.01	315.36	112329.0
2022-08-01 08:00:00	QQQ	ETF	314.98	315.696	314.5	314.77	156387.0
2022-08-01 08:30:00	QQQ	ETF	314.77	314.93	313.79	313.79	346118.0
2022-08-01 09:00:00	QQQ	ETF	313.77	313.92	313.22	313.63	737454.0
2022-08-01 09:30:00	QQQ	ETF	313.66	316.738	312.53	315.9	6330314.0
2022-08-01 10:00:00	QQQ	ETF	315.9	317.8	315.35	315.74	4306919.0
2022-08-01 10:30:00	QQQ	ETF	315.77	318.81	315.75	318.35	2989966.0
2022-08-01 11:00:00	QQQ	ETF	318.37	318.625	316.91	317.95	2287725.0
2022-08-01 11:30:00	QQQ	ETF	317.96	318.42	316.93	318.07	1790368.0
2022-08-01 12:00:00	QQQ	ETF	318.07	318.22	316.31	317.0001	1373468.0
2022-08-01 12:30:00	QQQ	ETF	317.0	317.099	315.96	316.42	1758709.0

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

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