PREVIEW / etf_30min / 2020-08-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-03.parquet
  size:    560 KB
  rows:    20,897

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-03 04:00:00	SPY	ETF	326.46	326.82	326.3	326.33	9902.0
2020-08-03 04:30:00	SPY	ETF	326.37	326.37	325.72	326.08	47774.0
2020-08-03 05:00:00	SPY	ETF	325.95	326.4	325.95	326.26	41510.0
2020-08-03 05:30:00	SPY	ETF	326.34	326.55	326.34	326.55	2437.0
2020-08-03 06:00:00	SPY	ETF	326.69	327.3	326.69	327.27	126064.0
2020-08-03 06:30:00	SPY	ETF	327.18	328.09	327.13	328.02	22201.0
2020-08-03 07:00:00	SPY	ETF	328.03	328.04	327.86	327.96	113502.0
2020-08-03 07:30:00	SPY	ETF	327.97	328.42	327.97	328.42	215995.0
2020-08-03 08:00:00	SPY	ETF	328.44	328.61	325.9	328.41	210240.0
2020-08-03 08:30:00	SPY	ETF	328.43	328.63	328.3	328.46	125849.0
2020-08-03 09:00:00	SPY	ETF	328.46	328.56	328.11	328.35	271014.0
2020-08-03 09:30:00	SPY	ETF	328.32	328.44	327.73	328.35	5355065.0
2020-08-03 10:00:00	SPY	ETF	328.345	329.28	328.345	328.6	6155161.0
2020-08-03 10:30:00	SPY	ETF	328.61	328.91	327.91	328.2199	2153682.0
2020-08-03 11:00:00	SPY	ETF	328.23	329.0	328.15	328.87	2881310.0
2020-08-03 11:30:00	SPY	ETF	328.89	329.38	328.84	329.06	2945350.0
2020-08-03 12:00:00	SPY	ETF	329.06	329.18	328.81	328.8699	1460476.0
2020-08-03 12:30:00	SPY	ETF	328.85	329.01	328.73	328.9	2081283.0
2020-08-03 13:00:00	SPY	ETF	328.91	329.27	328.8592	329.11	1768192.0
2020-08-03 13:30:00	SPY	ETF	329.1	329.21	328.8	329.08	1294116.0
2020-08-03 14:00:00	SPY	ETF	329.08	329.43	328.9	329.41	2630756.0
2020-08-03 14:30:00	SPY	ETF	329.41	329.62	329.311	329.47	2899293.0
2020-08-03 15:00:00	SPY	ETF	329.48	329.56	328.65	328.96	4383829.0
2020-08-03 15:30:00	SPY	ETF	328.97	329.35	328.39	328.76	8817038.0
2020-08-03 16:00:00	SPY	ETF	328.75	329.04	328.38	328.84	4050475.0
2020-08-03 16:30:00	SPY	ETF	328.84	329.06	328.67	328.94	420590.0
2020-08-03 17:00:00	SPY	ETF	328.96	328.97	328.75	328.78	1047841.0
2020-08-03 17:30:00	SPY	ETF	328.8	329.09	328.8	329.09	23448.0
2020-08-03 18:00:00	SPY	ETF	329.06	329.09	328.61	328.75	64122.0
2020-08-03 18:30:00	SPY	ETF	328.75	328.82	328.7	328.82	11073.0
2020-08-03 19:00:00	SPY	ETF	328.77	328.93	328.69	328.9	15298.0
2020-08-03 19:30:00	SPY	ETF	328.93	329.05	328.71	328.83	25484.0
2020-08-03 04:00:00	QQQ	ETF	266.7	267.17	266.7	266.9	45351.0
2020-08-03 04:30:00	QQQ	ETF	266.92	266.93	266.51	266.8	13747.0
2020-08-03 05:00:00	QQQ	ETF	266.92	266.92	266.6	266.75	12500.0
2020-08-03 05:30:00	QQQ	ETF	266.87	267.03	266.87	267.01	7129.0
2020-08-03 06:00:00	QQQ	ETF	266.91	267.68	266.91	267.63	13868.0
2020-08-03 06:30:00	QQQ	ETF	267.65	268.13	267.54	268.12	36944.0
2020-08-03 07:00:00	QQQ	ETF	268.09	268.18	267.93	268.1	142544.0
2020-08-03 07:30:00	QQQ	ETF	268.1	268.45	268.05	268.18	143413.0
2020-08-03 08:00:00	QQQ	ETF	268.2	268.38	266.0	268.09	164198.0
2020-08-03 08:30:00	QQQ	ETF	268.1	268.27	267.91	268.11	104175.0
2020-08-03 09:00:00	QQQ	ETF	268.11	268.21	267.65	268.03	239039.0
2020-08-03 09:30:00	QQQ	ETF	268.05	269.54	267.87	269.15	4160084.0
2020-08-03 10:00:00	QQQ	ETF	269.15	269.99	268.5908	268.9	2915912.0
2020-08-03 10:30:00	QQQ	ETF	268.94	269.3	268.1503	268.6	1838735.0
2020-08-03 11:00:00	QQQ	ETF	268.6	269.475	268.4401	269.33	1342459.0
2020-08-03 11:30:00	QQQ	ETF	269.36	269.645	269.05	269.645	1276234.0
2020-08-03 12:00:00	QQQ	ETF	269.65	269.68	269.18	269.525	851168.0
2020-08-03 12:30:00	QQQ	ETF	269.52	269.728	269.09	269.39	904141.0

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

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