PREVIEW / etf_30min / 2020-08-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-05.parquet
  size:    559 KB
  rows:    20,905

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-08-05 04:00:00	SPY	ETF	331.85	331.87	331.14	331.14	17289.0
2020-08-05 04:30:00	SPY	ETF	331.16	331.86	331.0	331.81	18237.0
2020-08-05 05:00:00	SPY	ETF	331.82	332.0	331.67	331.76	4165.0
2020-08-05 05:30:00	SPY	ETF	331.57	331.93	331.47	331.86	8259.0
2020-08-05 06:00:00	SPY	ETF	331.98	332.1	331.74	331.78	16487.0
2020-08-05 06:30:00	SPY	ETF	331.8	331.95	331.69	331.95	12001.0
2020-08-05 07:00:00	SPY	ETF	331.81	331.97	331.68	331.84	59717.0
2020-08-05 07:30:00	SPY	ETF	331.81	332.16	331.8	332.16	198562.0
2020-08-05 08:00:00	SPY	ETF	332.21	332.21	330.0	331.6801	286528.0
2020-08-05 08:30:00	SPY	ETF	331.75	332.0	331.52	331.64	119098.0
2020-08-05 09:00:00	SPY	ETF	331.63	331.69	331.42	331.47	172729.0
2020-08-05 09:30:00	SPY	ETF	331.47	331.93	331.23	331.88	3938908.0
2020-08-05 10:00:00	SPY	ETF	331.89	332.13	331.74	332.0	3068747.0
2020-08-05 10:30:00	SPY	ETF	331.99	332.16	331.62	331.85	3277036.0
2020-08-05 11:00:00	SPY	ETF	331.86	332.39	331.86	332.03	2608929.0
2020-08-05 11:30:00	SPY	ETF	332.04	332.3	331.62	331.64	2350930.0
2020-08-05 12:00:00	SPY	ETF	331.635	331.935	331.46	331.5054	2210685.0
2020-08-05 12:30:00	SPY	ETF	331.5	331.91	331.43	331.82	2024201.0
2020-08-05 13:00:00	SPY	ETF	331.82	331.94	331.66	331.87	1281527.0
2020-08-05 13:30:00	SPY	ETF	331.88	332.02	331.755	331.881	1867169.0
2020-08-05 14:00:00	SPY	ETF	331.885	332.2299	331.87	332.11	1335890.0
2020-08-05 14:30:00	SPY	ETF	332.11	332.18	331.73	331.88	2210546.0
2020-08-05 15:00:00	SPY	ETF	331.88	332.11	331.62	331.76	2359865.0
2020-08-05 15:30:00	SPY	ETF	331.77	332.34	331.18	332.06	8052590.0
2020-08-05 16:00:00	SPY	ETF	332.06	332.12	331.46	331.68	3535340.0
2020-08-05 16:30:00	SPY	ETF	331.64	332.11	331.63	331.85	985402.0
2020-08-05 17:00:00	SPY	ETF	331.74	331.85	331.72	331.83	44794.0
2020-08-05 17:30:00	SPY	ETF	331.8	331.83	331.75	331.75	27857.0
2020-08-05 18:00:00	SPY	ETF	331.75	332.04	331.62	331.99	61760.0
2020-08-05 18:30:00	SPY	ETF	332.0	332.04	331.9	332.01	16415.0
2020-08-05 19:00:00	SPY	ETF	332.04	332.15	331.88	332.08	44328.0
2020-08-05 19:30:00	SPY	ETF	332.11	332.13	331.91	332.0	16660.0
2020-08-05 04:00:00	QQQ	ETF	271.61	271.75	271.11	271.14	21425.0
2020-08-05 04:30:00	QQQ	ETF	271.09	271.5	270.94	271.47	15135.0
2020-08-05 05:00:00	QQQ	ETF	271.56	271.65	271.45	271.54	1520.0
2020-08-05 05:30:00	QQQ	ETF	271.55	271.82	271.35	271.79	14249.0
2020-08-05 06:00:00	QQQ	ETF	271.75	271.75	271.26	271.39	65817.0
2020-08-05 06:30:00	QQQ	ETF	271.45	271.46	271.12	271.21	89369.0
2020-08-05 07:00:00	QQQ	ETF	271.16	271.4	271.1	271.39	80556.0
2020-08-05 07:30:00	QQQ	ETF	271.38	271.59	271.29	271.37	109062.0
2020-08-05 08:00:00	QQQ	ETF	271.16	271.77	270.49	270.86	150648.0
2020-08-05 08:30:00	QQQ	ETF	270.93	271.02	270.42	270.53	87400.0
2020-08-05 09:00:00	QQQ	ETF	270.51	270.9	270.38	270.78	102817.0
2020-08-05 09:30:00	QQQ	ETF	270.86	271.155	269.96	271.03	3016606.0
2020-08-05 10:00:00	QQQ	ETF	271.05	271.49	270.79	271.24	2084909.0
2020-08-05 10:30:00	QQQ	ETF	271.26	271.28	270.55	270.86	1444447.0
2020-08-05 11:00:00	QQQ	ETF	270.86	271.52	270.7	270.895	1399607.0
2020-08-05 11:30:00	QQQ	ETF	270.895	271.12	270.46	270.6	1313588.0
2020-08-05 12:00:00	QQQ	ETF	270.6	271.169	270.6	270.655	763117.0
2020-08-05 12:30:00	QQQ	ETF	270.6538	271.0	270.59	270.88	803455.0

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

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