PREVIEW / etf_30min / 2020-09-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-24.parquet
  size:    559 KB
  rows:    20,849

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
2020-09-24 04:00:00	SPY	ETF	323.0	323.17	321.95	322.3	19395.0
2020-09-24 04:30:00	SPY	ETF	322.49	322.87	322.12	322.37	13310.0
2020-09-24 05:00:00	SPY	ETF	322.2	322.58	321.87	322.48	21469.0
2020-09-24 05:30:00	SPY	ETF	322.77	322.77	322.22	322.48	19577.0
2020-09-24 06:00:00	SPY	ETF	322.64	323.53	322.64	323.37	41930.0
2020-09-24 06:30:00	SPY	ETF	323.3	323.62	323.28	323.32	51048.0
2020-09-24 07:00:00	SPY	ETF	323.26	323.35	322.59	322.86	124428.0
2020-09-24 07:30:00	SPY	ETF	322.86	322.99	321.88	321.96	412086.0
2020-09-24 08:00:00	SPY	ETF	321.99	323.4304	321.25	321.7	670470.0
2020-09-24 08:30:00	SPY	ETF	321.7	321.87	320.18	320.7	793741.0
2020-09-24 09:00:00	SPY	ETF	320.71	321.37	320.0	321.21	423980.0
2020-09-24 09:30:00	SPY	ETF	321.22	322.84	319.8	322.19	10603088.0
2020-09-24 10:00:00	SPY	ETF	322.19	324.6476	322.17	322.66	6772924.0
2020-09-24 10:30:00	SPY	ETF	322.66	323.26	321.24	323.15	6000502.0
2020-09-24 11:00:00	SPY	ETF	323.16	323.56	321.87	323.0222	3568605.0
2020-09-24 11:30:00	SPY	ETF	323.01	324.54	322.891	324.52	3366604.0
2020-09-24 12:00:00	SPY	ETF	324.515	325.31	324.4	324.75	3696554.0
2020-09-24 12:30:00	SPY	ETF	324.75	325.15	323.51	325.09	3299537.0
2020-09-24 13:00:00	SPY	ETF	325.095	326.425	325.0	326.315	3696041.0
2020-09-24 13:30:00	SPY	ETF	326.32	326.797	325.66	325.78	3250348.0
2020-09-24 14:00:00	SPY	ETF	325.79	326.07	324.2701	324.5381	3918812.0
2020-09-24 14:30:00	SPY	ETF	324.54	325.5599	322.86	322.9599	4780017.0
2020-09-24 15:00:00	SPY	ETF	322.96	323.87	321.9	322.27	6289937.0
2020-09-24 15:30:00	SPY	ETF	322.28	324.28	321.85	323.52	9674511.0
2020-09-24 16:00:00	SPY	ETF	323.53	323.98	323.31	323.7	2436637.0
2020-09-24 16:30:00	SPY	ETF	323.71	324.33	323.5	324.01	208057.0
2020-09-24 17:00:00	SPY	ETF	324.17	324.19	323.94	324.09	20023.0
2020-09-24 17:30:00	SPY	ETF	324.0	324.3	323.96	324.2	16525.0
2020-09-24 18:00:00	SPY	ETF	324.3	324.88	324.3	324.7	62150.0
2020-09-24 18:30:00	SPY	ETF	324.67	325.0	324.58	324.62	36246.0
2020-09-24 19:00:00	SPY	ETF	324.61	325.3	324.6	325.25	41763.0
2020-09-24 19:30:00	SPY	ETF	325.2	325.44	325.1	325.35	91279.0
2020-09-24 04:00:00	QQQ	ETF	264.07	264.08	262.65	263.06	9873.0
2020-09-24 04:30:00	QQQ	ETF	263.1	263.57	262.67	262.92	13545.0
2020-09-24 05:00:00	QQQ	ETF	262.75	263.0	262.3	263.0	9571.0
2020-09-24 05:30:00	QQQ	ETF	262.96	262.97	262.41	262.85	4427.0
2020-09-24 06:00:00	QQQ	ETF	262.95	263.97	262.95	263.77	86483.0
2020-09-24 06:30:00	QQQ	ETF	263.79	264.16	263.67	263.9	67859.0
2020-09-24 07:00:00	QQQ	ETF	263.84	263.849	263.12	263.4	102393.0
2020-09-24 07:30:00	QQQ	ETF	263.49	263.8	262.43	262.48	251241.0
2020-09-24 08:00:00	QQQ	ETF	262.5	264.02	261.59	262.1	415412.0
2020-09-24 08:30:00	QQQ	ETF	261.81	262.08	260.3	260.81	610169.0
2020-09-24 09:00:00	QQQ	ETF	260.81	261.76	260.24	261.59	387488.0
2020-09-24 09:30:00	QQQ	ETF	261.59	265.345	261.22	264.455	6659582.0
2020-09-24 10:00:00	QQQ	ETF	264.49	266.89	264.49	264.68	5413346.0
2020-09-24 10:30:00	QQQ	ETF	264.66	265.86	262.94	265.79	6070497.0
2020-09-24 11:00:00	QQQ	ETF	265.78	266.6099	264.1	266.15	3007860.0
2020-09-24 11:30:00	QQQ	ETF	266.14	267.48	266.1	267.2413	2368179.0
2020-09-24 12:00:00	QQQ	ETF	267.28	267.975	266.5901	266.97	2498479.0
2020-09-24 12:30:00	QQQ	ETF	267.02	267.265	265.68	267.215	2278605.0

> showing 50 of 20,849 rows — these rows as CSV

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