PREVIEW / etf_30min / 2020-01-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-14.parquet
  size:    547 KB
  rows:    19,289

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-01-14 04:00:00	SPY	ETF	327.31	327.74	327.31	327.74	11699.0
2020-01-14 04:30:00	SPY	ETF	327.82	328.34	327.82	328.16	7563.0
2020-01-14 05:00:00	SPY	ETF	328.14	328.22	327.96	328.1	15307.0
2020-01-14 05:30:00	SPY	ETF	328.02	328.02	327.5	327.73	9671.0
2020-01-14 06:00:00	SPY	ETF	327.7	327.82	327.24	327.57	11929.0
2020-01-14 06:30:00	SPY	ETF	327.56	327.8	327.39	327.76	25047.0
2020-01-14 07:00:00	SPY	ETF	327.83	327.98	327.71	327.96	33737.0
2020-01-14 07:30:00	SPY	ETF	327.96	327.98	327.69	327.77	46744.0
2020-01-14 08:00:00	SPY	ETF	327.7901	327.9799	326.76	327.7	59125.0
2020-01-14 08:30:00	SPY	ETF	327.74	328.06	327.53	327.95	133756.0
2020-01-14 09:00:00	SPY	ETF	327.95	327.97	327.43	327.45	117548.0
2020-01-14 09:30:00	SPY	ETF	327.47	327.75	327.06	327.13	6523412.0
2020-01-14 10:00:00	SPY	ETF	327.135	327.63	327.04	327.49	3345511.0
2020-01-14 10:30:00	SPY	ETF	327.4901	327.8	327.245	327.55	3980164.0
2020-01-14 11:00:00	SPY	ETF	327.55	327.84	327.5	327.775	1665905.0
2020-01-14 11:30:00	SPY	ETF	327.77	327.98	327.66	327.97	1125919.0
2020-01-14 12:00:00	SPY	ETF	327.975	328.14	327.9	328.08	1040430.0
2020-01-14 12:30:00	SPY	ETF	328.07	328.4	328.07	328.29	1591280.0
2020-01-14 13:00:00	SPY	ETF	328.29	328.55	328.28	328.489	1625394.0
2020-01-14 13:30:00	SPY	ETF	328.48	328.62	327.39	327.61	7755537.0
2020-01-14 14:00:00	SPY	ETF	327.62	327.72	326.844	327.67	7688129.0
2020-01-14 14:30:00	SPY	ETF	327.68	328.06	327.54	327.59	3935539.0
2020-01-14 15:00:00	SPY	ETF	327.59	327.9774	327.08	327.155	4186534.0
2020-01-14 15:30:00	SPY	ETF	327.155	327.9774	326.98	327.43	9333476.0
2020-01-14 16:00:00	SPY	ETF	327.42	327.94	327.152	327.8	5631007.0
2020-01-14 16:30:00	SPY	ETF	327.81	327.93	327.81	327.89	220073.0
2020-01-14 17:00:00	SPY	ETF	327.92	327.92	327.45	327.9	663576.0
2020-01-14 17:30:00	SPY	ETF	327.92	327.92	327.45	327.9	39117.0
2020-01-14 18:00:00	SPY	ETF	327.85	327.85	327.42	327.44	75975.0
2020-01-14 18:30:00	SPY	ETF	327.55	327.55	327.01	327.01	104601.0
2020-01-14 19:00:00	SPY	ETF	327.05	327.34	326.93	327.32	42612.0
2020-01-14 19:30:00	SPY	ETF	327.31	327.33	327.13	327.23	24637.0
2020-01-14 04:00:00	QQQ	ETF	220.6	220.8	220.51	220.73	36460.0
2020-01-14 04:30:00	QQQ	ETF	220.82	221.21	220.82	221.13	17402.0
2020-01-14 05:00:00	QQQ	ETF	221.11	221.22	220.94	220.99	35827.0
2020-01-14 05:30:00	QQQ	ETF	221.04	221.08	220.5	220.75	22736.0
2020-01-14 06:00:00	QQQ	ETF	220.75	220.87	220.41	220.55	9178.0
2020-01-14 06:30:00	QQQ	ETF	220.58	220.73	220.5	220.6	21012.0
2020-01-14 07:00:00	QQQ	ETF	220.7	220.91	220.59	220.9	62366.0
2020-01-14 07:30:00	QQQ	ETF	220.91	220.96	220.7	220.84	55732.0
2020-01-14 08:00:00	QQQ	ETF	221.1	221.17	220.02	220.85	112484.0
2020-01-14 08:30:00	QQQ	ETF	220.8	221.1	220.73	221.0	91294.0
2020-01-14 09:00:00	QQQ	ETF	221.05	221.05	220.55	220.78	104657.0
2020-01-14 09:30:00	QQQ	ETF	220.76	220.99	219.77	219.8829	3027257.0
2020-01-14 10:00:00	QQQ	ETF	219.89	220.67	219.74	220.54	1885432.0
2020-01-14 10:30:00	QQQ	ETF	220.555	220.83	220.06	220.36	1261844.0
2020-01-14 11:00:00	QQQ	ETF	220.35	220.565	220.26	220.475	640878.0
2020-01-14 11:30:00	QQQ	ETF	220.4702	220.77	220.36	220.76	593495.0
2020-01-14 12:00:00	QQQ	ETF	220.76	220.9	220.66	220.7866	1006953.0
2020-01-14 12:30:00	QQQ	ETF	220.78	221.07	220.78	220.83	597535.0

> showing 50 of 19,289 rows — these rows as CSV

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