PREVIEW / etf_30min / 2019-10-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-23.parquet
  size:    497 KB
  rows:    17,107

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
2019-10-23 04:00:00	SPY	ETF	298.6	299.0	298.6	298.85	10661.0
2019-10-23 04:30:00	SPY	ETF	298.75	298.8	298.7	298.75	1720.0
2019-10-23 05:00:00	SPY	ETF	298.79	298.83	298.73	298.76	2430.0
2019-10-23 05:30:00	SPY	ETF	298.68	298.8	298.65	298.7	6719.0
2019-10-23 06:00:00	SPY	ETF	299.1	299.22	298.88	298.94	14515.0
2019-10-23 06:30:00	SPY	ETF	298.87	298.87	298.24	298.3	69682.0
2019-10-23 07:00:00	SPY	ETF	298.35	298.49	298.01	298.09	94216.0
2019-10-23 07:30:00	SPY	ETF	298.06	298.51	297.92	298.44	176277.0
2019-10-23 08:00:00	SPY	ETF	298.46	298.7	297.97	298.69	112475.0
2019-10-23 08:30:00	SPY	ETF	298.72	298.85	298.63	298.65	91086.0
2019-10-23 09:00:00	SPY	ETF	298.65	298.79	298.59	298.74	96272.0
2019-10-23 09:30:00	SPY	ETF	298.73	299.39	298.495	299.28	3725262.0
2019-10-23 10:00:00	SPY	ETF	299.29	299.38	298.86	299.05	2239797.0
2019-10-23 10:30:00	SPY	ETF	299.06	299.57	298.77	299.43	2000340.0
2019-10-23 11:00:00	SPY	ETF	299.425	299.76	299.375	299.64	1816502.0
2019-10-23 11:30:00	SPY	ETF	299.65	299.76	299.4	299.44	1175428.0
2019-10-23 12:00:00	SPY	ETF	299.43	299.5	299.22	299.31	1686169.0
2019-10-23 12:30:00	SPY	ETF	299.3	299.59	299.28	299.325	879700.0
2019-10-23 13:00:00	SPY	ETF	299.32	299.5	299.14	299.29	757728.0
2019-10-23 13:30:00	SPY	ETF	299.29	299.44	299.22	299.29	1205240.0
2019-10-23 14:00:00	SPY	ETF	299.295	299.295	298.87	298.93	2109378.0
2019-10-23 14:30:00	SPY	ETF	298.92	299.09	298.79	299.06	1950249.0
2019-10-23 15:00:00	SPY	ETF	299.05	299.35	298.94	299.33	1613715.0
2019-10-23 15:30:00	SPY	ETF	299.33	299.94	299.31	299.86	7551070.0
2019-10-23 16:00:00	SPY	ETF	299.86	300.09	299.79	300.08	3905208.0
2019-10-23 16:30:00	SPY	ETF	300.06	300.11	299.94	300.07	386596.0
2019-10-23 17:00:00	SPY	ETF	300.07	300.15	300.0	300.15	133033.0
2019-10-23 17:30:00	SPY	ETF	300.09	300.09	300.0	300.0	27911.0
2019-10-23 18:00:00	SPY	ETF	300.07	300.45	300.07	300.32	56267.0
2019-10-23 18:30:00	SPY	ETF	300.35	300.36	300.21	300.24	17033.0
2019-10-23 19:00:00	SPY	ETF	300.34	300.34	300.16	300.2	13254.0
2019-10-23 19:30:00	SPY	ETF	300.2	300.3	300.13	300.2	36996.0
2019-10-23 04:00:00	QQQ	ETF	190.84	191.35	190.84	191.24	20036.0
2019-10-23 04:30:00	QQQ	ETF	191.23	191.23	191.15	191.16	12950.0
2019-10-23 05:00:00	QQQ	ETF	191.19	191.24	191.12	191.12	7300.0
2019-10-23 05:30:00	QQQ	ETF	191.12	191.21	191.09	191.21	16557.0
2019-10-23 06:00:00	QQQ	ETF	191.24	191.55	191.23	191.38	24804.0
2019-10-23 06:30:00	QQQ	ETF	191.35	191.35	190.88	190.97	32240.0
2019-10-23 07:00:00	QQQ	ETF	190.98	191.11	190.7	190.83	75058.0
2019-10-23 07:30:00	QQQ	ETF	190.79	191.08	190.72	191.08	102904.0
2019-10-23 08:00:00	QQQ	ETF	191.0801	191.45	190.73	191.43	213611.0
2019-10-23 08:30:00	QQQ	ETF	191.42	191.46	191.3	191.33	86065.0
2019-10-23 09:00:00	QQQ	ETF	191.32	191.47	191.28	191.41	108949.0
2019-10-23 09:30:00	QQQ	ETF	191.43	191.9853	191.15	191.7771	2001744.0
2019-10-23 10:00:00	QQQ	ETF	191.78	191.87	191.32	191.56	1089454.0
2019-10-23 10:30:00	QQQ	ETF	191.57	192.1	191.17	191.94	1385654.0
2019-10-23 11:00:00	QQQ	ETF	191.93	192.24	191.84	192.18	604613.0
2019-10-23 11:30:00	QQQ	ETF	192.19	192.2582	191.78	191.83	632037.0
2019-10-23 12:00:00	QQQ	ETF	191.8491	191.91	191.625	191.77	593897.0
2019-10-23 12:30:00	QQQ	ETF	191.75	192.07	191.735	191.96	431933.0

> showing 50 of 17,107 rows — these rows as CSV

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