PREVIEW / etf_30min / 2020-06-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-05.parquet
  size:    601 KB
  rows:    22,472

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-06-05 04:00:00	SPY	ETF	314.69	314.8	314.35	314.4	38376.0
2020-06-05 04:30:00	SPY	ETF	314.49	314.64	313.71	314.13	40432.0
2020-06-05 05:00:00	SPY	ETF	314.22	314.42	313.77	313.77	43422.0
2020-06-05 05:30:00	SPY	ETF	313.71	313.88	313.42	313.87	34617.0
2020-06-05 06:00:00	SPY	ETF	313.8	313.82	313.17	313.36	63867.0
2020-06-05 06:30:00	SPY	ETF	313.22	313.58	313.22	313.57	28984.0
2020-06-05 07:00:00	SPY	ETF	313.58	313.99	313.57	313.97	137501.0
2020-06-05 07:30:00	SPY	ETF	313.95	314.08	313.83	313.915	182678.0
2020-06-05 08:00:00	SPY	ETF	313.87	314.47	312.72	313.75	257478.0
2020-06-05 08:30:00	SPY	ETF	313.82	316.74	313.77	316.3	4156963.0
2020-06-05 09:00:00	SPY	ETF	316.31	318.16	316.16	317.26	2378937.0
2020-06-05 09:30:00	SPY	ETF	317.23	318.65	317.16	317.65	13969332.0
2020-06-05 10:00:00	SPY	ETF	317.64	318.68	317.495	318.05	9404436.0
2020-06-05 10:30:00	SPY	ETF	318.05	319.19	317.92	319.154	5827516.0
2020-06-05 11:00:00	SPY	ETF	319.17	320.67	319.07	320.61	12300552.0
2020-06-05 11:30:00	SPY	ETF	320.61	321.275	320.06	320.32	8599780.0
2020-06-05 12:00:00	SPY	ETF	320.32	320.45	319.22	319.88	6866451.0
2020-06-05 12:30:00	SPY	ETF	319.88	320.35	319.83	320.13	4361047.0
2020-06-05 13:00:00	SPY	ETF	320.13	320.66	319.68	320.6523	4459466.0
2020-06-05 13:30:00	SPY	ETF	320.64	320.74	320.0	320.07	4279524.0
2020-06-05 14:00:00	SPY	ETF	320.07	320.61	319.81	320.2	6854215.0
2020-06-05 14:30:00	SPY	ETF	320.2	320.5599	319.3	319.7	10180979.0
2020-06-05 15:00:00	SPY	ETF	319.7	320.14	318.935	320.09	13050211.0
2020-06-05 15:30:00	SPY	ETF	320.085	320.1	318.37	319.27	22038200.0
2020-06-05 16:00:00	SPY	ETF	319.24	319.59	318.8	319.0	18530364.0
2020-06-05 16:30:00	SPY	ETF	319.04	319.34	318.85	318.85	386853.0
2020-06-05 17:00:00	SPY	ETF	318.81	319.04	318.81	318.98	157082.0
2020-06-05 17:30:00	SPY	ETF	318.9999	319.34	318.91	318.92	78615.0
2020-06-05 18:00:00	SPY	ETF	318.92	318.97	318.86	318.87	79872.0
2020-06-05 18:30:00	SPY	ETF	318.9	318.98	318.8	318.9	66561.0
2020-06-05 19:00:00	SPY	ETF	318.86	319.15	318.85	319.01	32060.0
2020-06-05 19:30:00	SPY	ETF	319.12	319.26	319.07	319.15	36609.0
2020-06-05 04:00:00	QQQ	ETF	236.71	236.74	236.4	236.4	18062.0
2020-06-05 04:30:00	QQQ	ETF	236.37	236.55	235.87	236.13	18370.0
2020-06-05 05:00:00	QQQ	ETF	236.19	236.3	235.95	235.95	7080.0
2020-06-05 05:30:00	QQQ	ETF	235.89	236.04	235.74	235.92	7676.0
2020-06-05 06:00:00	QQQ	ETF	235.74	235.77	235.49	235.6	33550.0
2020-06-05 06:30:00	QQQ	ETF	235.65	235.73	235.48	235.62	11700.0
2020-06-05 07:00:00	QQQ	ETF	235.68	235.959	235.64	235.95	104520.0
2020-06-05 07:30:00	QQQ	ETF	235.94	235.96	235.44	235.44	113284.0
2020-06-05 08:00:00	QQQ	ETF	235.43	236.75	235.13	235.29	176032.0
2020-06-05 08:30:00	QQQ	ETF	235.26	236.01	234.4	235.37	1181876.0
2020-06-05 09:00:00	QQQ	ETF	235.44	240.0	235.41	236.05	654791.0
2020-06-05 09:30:00	QQQ	ETF	236.06	238.65	235.63	238.12	6985398.0
2020-06-05 10:00:00	QQQ	ETF	238.13	238.56	237.64	238.18	3187562.0
2020-06-05 10:30:00	QQQ	ETF	238.2	238.85	238.01	238.65	2432189.0
2020-06-05 11:00:00	QQQ	ETF	238.65	239.6499	238.56	239.4	2783586.0
2020-06-05 11:30:00	QQQ	ETF	239.4	239.82	239.07	239.44	2194952.0
2020-06-05 12:00:00	QQQ	ETF	239.44	239.87	239.28	239.8	1878261.0
2020-06-05 12:30:00	QQQ	ETF	239.81	240.17	239.59	239.92	1997171.0

> showing 50 of 22,472 rows — these rows as CSV

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