PREVIEW / etf_30min / 2022-08-10

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-10.parquet
  size:    665 KB
  rows:    26,642

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-10 04:00:00	SPY	ETF	411.65	412.15	411.49	412.15	8469.0
2022-08-10 04:30:00	SPY	ETF	412.15	412.75	412.15	412.62	6509.0
2022-08-10 05:00:00	SPY	ETF	412.54	412.81	412.51	412.51	5183.0
2022-08-10 05:30:00	SPY	ETF	412.36	412.39	412.26	412.38	5072.0
2022-08-10 06:00:00	SPY	ETF	412.36	412.44	412.19	412.4	13470.0
2022-08-10 06:30:00	SPY	ETF	412.34	412.34	412.02	412.21	6901.0
2022-08-10 07:00:00	SPY	ETF	412.21	412.49	412.12	412.34	34366.0
2022-08-10 07:30:00	SPY	ETF	412.35	412.72	412.32	412.7	66042.0
2022-08-10 08:00:00	SPY	ETF	412.19	413.58	410.95	412.96	930533.0
2022-08-10 08:30:00	SPY	ETF	413.01	419.0	411.35	418.09	2468578.0
2022-08-10 09:00:00	SPY	ETF	418.08	418.88	417.79	418.67	793402.0
2022-08-10 09:30:00	SPY	ETF	418.79	418.86	417.205	418.2	7432514.0
2022-08-10 10:00:00	SPY	ETF	418.21	418.62	416.72	417.66	3738836.0
2022-08-10 10:30:00	SPY	ETF	417.67	418.84	417.52	418.77	3250542.0
2022-08-10 11:00:00	SPY	ETF	418.77	420.04	418.77	419.295	4285559.0
2022-08-10 11:30:00	SPY	ETF	419.31	419.64	418.92	419.59	2212415.0
2022-08-10 12:00:00	SPY	ETF	419.59	419.79	418.33	418.81	2271035.0
2022-08-10 12:30:00	SPY	ETF	418.83	419.1	418.68	419.0607	1625472.0
2022-08-10 13:00:00	SPY	ETF	419.065	419.49	418.7	419.0106	1993302.0
2022-08-10 13:30:00	SPY	ETF	419.025	419.81	418.725	419.4299	2217801.0
2022-08-10 14:00:00	SPY	ETF	419.43	419.625	419.06	419.12	1917881.0
2022-08-10 14:30:00	SPY	ETF	419.13	419.325	418.46	418.4901	2011567.0
2022-08-10 15:00:00	SPY	ETF	418.4916	419.425	418.35	419.36	2290110.0
2022-08-10 15:30:00	SPY	ETF	419.35	420.14	419.17	419.95	8824859.0
2022-08-10 16:00:00	SPY	ETF	419.94	420.0	418.9	419.96	3485101.0
2022-08-10 16:30:00	SPY	ETF	419.98	420.17	419.94	419.95	202645.0
2022-08-10 17:00:00	SPY	ETF	419.99	420.0	419.8	419.94	110531.0
2022-08-10 17:30:00	SPY	ETF	419.94	419.95	419.84	419.94	31655.0
2022-08-10 18:00:00	SPY	ETF	419.92	419.92	419.63	419.68	25460.0
2022-08-10 18:30:00	SPY	ETF	419.68	419.7	419.59	419.66	13832.0
2022-08-10 19:00:00	SPY	ETF	419.62	419.91	419.6	419.89	52396.0
2022-08-10 19:30:00	SPY	ETF	419.9	420.2	419.27	420.08	50295.0
2022-08-10 04:00:00	QQQ	ETF	316.95	317.63	316.9	317.63	29120.0
2022-08-10 04:30:00	QQQ	ETF	317.83	318.55	317.83	318.4	45419.0
2022-08-10 05:00:00	QQQ	ETF	318.46	318.76	318.13	318.3	19475.0
2022-08-10 05:30:00	QQQ	ETF	318.19	318.25	317.96	318.07	13492.0
2022-08-10 06:00:00	QQQ	ETF	317.91	318.04	317.78	317.98	11552.0
2022-08-10 06:30:00	QQQ	ETF	317.89	317.91	317.48	317.74	95598.0
2022-08-10 07:00:00	QQQ	ETF	317.74	318.2	317.55	318.12	51124.0
2022-08-10 07:30:00	QQQ	ETF	318.1	318.42	318.04	318.39	90371.0
2022-08-10 08:00:00	QQQ	ETF	317.61	319.79	316.11	318.76	437022.0
2022-08-10 08:30:00	QQQ	ETF	318.61	325.38	318.51	324.26	3457984.0
2022-08-10 09:00:00	QQQ	ETF	324.3	324.68	323.79	324.58	799336.0
2022-08-10 09:30:00	QQQ	ETF	324.59	325.05	322.81	323.99	7993332.0
2022-08-10 10:00:00	QQQ	ETF	324.01	324.405	322.0601	323.145	3592414.0
2022-08-10 10:30:00	QQQ	ETF	323.15	324.56	322.89	324.31	2505389.0
2022-08-10 11:00:00	QQQ	ETF	324.34	325.59	324.34	324.97	2723943.0
2022-08-10 11:30:00	QQQ	ETF	324.9492	325.55	324.615	325.47	1982937.0
2022-08-10 12:00:00	QQQ	ETF	325.46	325.71	323.97	324.51	1853917.0
2022-08-10 12:30:00	QQQ	ETF	324.52	324.85	324.2417	324.5718	1039831.0

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

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