PREVIEW / etf_30min / 2021-06-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-18.parquet
  size:    622 KB
  rows:    24,079

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
2021-06-18 04:00:00	SPY	ETF	420.6	422.1	420.43	420.58	34134.0
2021-06-18 04:30:00	SPY	ETF	420.58	420.7	420.53	420.55	3563.0
2021-06-18 05:00:00	SPY	ETF	420.55	420.78	420.5	420.78	16165.0
2021-06-18 05:30:00	SPY	ETF	420.7	420.83	420.51	420.62	5391.0
2021-06-18 06:00:00	SPY	ETF	420.57	420.57	420.05	420.21	24794.0
2021-06-18 06:30:00	SPY	ETF	420.23	420.45	420.16	420.3	15205.0
2021-06-18 07:00:00	SPY	ETF	420.19	420.31	419.21	419.7	123916.0
2021-06-18 07:30:00	SPY	ETF	419.56	419.78	419.17	419.62	102404.0
2021-06-18 08:00:00	SPY	ETF	419.29	422.276	416.94	417.8	1185517.0
2021-06-18 08:30:00	SPY	ETF	417.78	418.55	417.2	418.51	503975.0
2021-06-18 09:00:00	SPY	ETF	418.57	418.59	417.06	417.1	707697.0
2021-06-18 09:30:00	SPY	ETF	417.08	417.8281	416.28	417.23	10802279.0
2021-06-18 10:00:00	SPY	ETF	417.22	417.455	416.11	416.66	6348222.0
2021-06-18 10:30:00	SPY	ETF	416.66	417.21	415.85	416.195	4863440.0
2021-06-18 11:00:00	SPY	ETF	416.19	416.5481	415.61	415.66	5052491.0
2021-06-18 11:30:00	SPY	ETF	415.65	416.9	415.585	416.7699	3289942.0
2021-06-18 12:00:00	SPY	ETF	416.75	417.26	416.41	417.26	2384355.0
2021-06-18 12:30:00	SPY	ETF	417.25	417.265	416.31	416.715	2130400.0
2021-06-18 13:00:00	SPY	ETF	416.71	417.24	416.46	416.4801	2144239.0
2021-06-18 13:30:00	SPY	ETF	416.485	416.96	416.065	416.635	2035234.0
2021-06-18 14:00:00	SPY	ETF	416.63	417.13	416.37	416.8	1886672.0
2021-06-18 14:30:00	SPY	ETF	416.8	416.875	415.72	415.8699	2894571.0
2021-06-18 15:00:00	SPY	ETF	415.87	416.94	415.605	416.55	4767806.0
2021-06-18 15:30:00	SPY	ETF	416.55	416.94	414.7	415.0	12750511.0
2021-06-18 16:00:00	SPY	ETF	415.01	415.0475	414.28	414.58	8757857.0
2021-06-18 16:30:00	SPY	ETF	414.57	415.0565	413.64	413.75	698145.0
2021-06-18 17:00:00	SPY	ETF	413.73	414.13	413.6	414.0	304855.0
2021-06-18 17:30:00	SPY	ETF	414.0	414.92	413.88	413.94	2978749.0
2021-06-18 18:00:00	SPY	ETF	413.93	414.92	413.66	413.72	38850.0
2021-06-18 18:30:00	SPY	ETF	414.92	414.92	413.66	413.84	22525.0
2021-06-18 19:00:00	SPY	ETF	413.85	413.85	413.65	413.74	17282.0
2021-06-18 19:30:00	SPY	ETF	413.77	413.77	413.56	413.6	23489.0
2021-06-18 04:00:00	QQQ	ETF	345.34	346.5	345.34	346.02	27067.0
2021-06-18 04:30:00	QQQ	ETF	345.98	346.14	345.98	346.02	19017.0
2021-06-18 05:00:00	QQQ	ETF	345.99	346.15	345.92	346.04	20301.0
2021-06-18 05:30:00	QQQ	ETF	346.05	346.18	345.98	346.12	14220.0
2021-06-18 06:00:00	QQQ	ETF	346.11	346.11	345.76	345.99	40557.0
2021-06-18 06:30:00	QQQ	ETF	346.01	346.08	345.85	345.98	18782.0
2021-06-18 07:00:00	QQQ	ETF	346.0	346.0	344.93	345.43	117354.0
2021-06-18 07:30:00	QQQ	ETF	345.37	345.51	344.9	345.41	108430.0
2021-06-18 08:00:00	QQQ	ETF	346.0096	346.31	342.9	343.36	467256.0
2021-06-18 08:30:00	QQQ	ETF	343.37	344.23	343.11	344.18	300321.0
2021-06-18 09:00:00	QQQ	ETF	344.16	344.21	343.43	343.6	342397.0
2021-06-18 09:30:00	QQQ	ETF	343.63	344.8082	342.68	343.96	6212929.0
2021-06-18 10:00:00	QQQ	ETF	343.96	344.42	343.25	344.185	3300535.0
2021-06-18 10:30:00	QQQ	ETF	344.18	344.6399	343.15	343.448	2288391.0
2021-06-18 11:00:00	QQQ	ETF	343.44	343.84	341.96	341.96	2740856.0
2021-06-18 11:30:00	QQQ	ETF	341.95	343.1	341.86	342.88	1979095.0
2021-06-18 12:00:00	QQQ	ETF	342.88	343.79	342.685	343.7808	1875385.0
2021-06-18 12:30:00	QQQ	ETF	343.783	343.8599	343.04	343.62	1333115.0

> showing 50 of 24,079 rows — these rows as CSV

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