PREVIEW / etf_30min / 2019-11-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-14.parquet
  size:    506 KB
  rows:    17,767

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-11-14 04:00:00	SPY	ETF	308.91	309.01	308.69	309.01	2821.0
2019-11-14 04:30:00	SPY	ETF	308.9	308.91	308.83	308.91	1500.0
2019-11-14 05:00:00	SPY	ETF	308.93	309.52	308.93	309.3	7892.0
2019-11-14 05:30:00	SPY	ETF	309.3	309.32	309.05	309.1	4695.0
2019-11-14 06:00:00	SPY	ETF	309.05	309.05	308.83	308.91	10710.0
2019-11-14 06:30:00	SPY	ETF	308.95	309.15	308.95	309.1	45568.0
2019-11-14 07:00:00	SPY	ETF	309.17	309.22	308.98	309.03	23871.0
2019-11-14 07:30:00	SPY	ETF	308.99	309.02	308.9	309.02	52462.0
2019-11-14 08:00:00	SPY	ETF	309.02	309.17	308.7	308.91	105106.0
2019-11-14 08:30:00	SPY	ETF	308.9	309.0	308.66	308.81	262900.0
2019-11-14 09:00:00	SPY	ETF	308.81	308.92	308.74	308.77	98659.0
2019-11-14 09:30:00	SPY	ETF	308.79	309.2	308.7	309.2	2303841.0
2019-11-14 10:00:00	SPY	ETF	309.19	309.46	309.12	309.25	2434006.0
2019-11-14 10:30:00	SPY	ETF	309.245	309.31	308.83	308.86	3022225.0
2019-11-14 11:00:00	SPY	ETF	308.85	309.35	308.81	309.15	2369693.0
2019-11-14 11:30:00	SPY	ETF	309.145	309.2	308.09	308.4	5957495.0
2019-11-14 12:00:00	SPY	ETF	308.39	309.2036	308.31	308.74	2135011.0
2019-11-14 12:30:00	SPY	ETF	308.7319	309.06	308.72	309.025	2629459.0
2019-11-14 13:00:00	SPY	ETF	309.02	309.16	308.87	308.9192	2071496.0
2019-11-14 13:30:00	SPY	ETF	308.91	309.08	308.24	308.74	3953893.0
2019-11-14 14:00:00	SPY	ETF	308.75	309.23	308.58	309.17	3546195.0
2019-11-14 14:30:00	SPY	ETF	309.1699	309.31	309.12	309.275	2486322.0
2019-11-14 15:00:00	SPY	ETF	309.28	309.445	309.11	309.44	3697858.0
2019-11-14 15:30:00	SPY	ETF	309.435	309.64	309.36	309.53	8677171.0
2019-11-14 16:00:00	SPY	ETF	309.54	309.74	309.2036	309.58	4106291.0
2019-11-14 16:30:00	SPY	ETF	309.59	309.68	309.59	309.67	580399.0
2019-11-14 17:00:00	SPY	ETF	309.67	309.67	309.53	309.6	121175.0
2019-11-14 17:30:00	SPY	ETF	309.61	309.62	309.55	309.6	8823.0
2019-11-14 18:00:00	SPY	ETF	309.6	309.6	309.5	309.5	52361.0
2019-11-14 18:30:00	SPY	ETF	309.51	309.81	309.51	309.8	26995.0
2019-11-14 19:00:00	SPY	ETF	309.8	309.8	309.61	309.7	662238.0
2019-11-14 19:30:00	SPY	ETF	309.72	310.69	309.72	310.62	80378.0
2019-11-14 04:00:00	QQQ	ETF	201.06	201.18	200.92	201.17	14900.0
2019-11-14 04:30:00	QQQ	ETF	201.13	201.18	201.04	201.14	9721.0
2019-11-14 05:00:00	QQQ	ETF	201.26	201.52	201.26	201.36	25619.0
2019-11-14 05:30:00	QQQ	ETF	201.4	201.43	201.14	201.14	9500.0
2019-11-14 06:00:00	QQQ	ETF	201.13	201.17	200.98	201.06	16768.0
2019-11-14 06:30:00	QQQ	ETF	201.06	201.19	201.06	201.16	12182.0
2019-11-14 07:00:00	QQQ	ETF	201.2	201.24	201.06	201.07	18093.0
2019-11-14 07:30:00	QQQ	ETF	201.03	201.08	200.92	201.02	36127.0
2019-11-14 08:00:00	QQQ	ETF	201.19	201.45	200.95	200.97	37464.0
2019-11-14 08:30:00	QQQ	ETF	200.87	201.07	200.75	200.85	118181.0
2019-11-14 09:00:00	QQQ	ETF	200.9	200.97	200.77	200.83	73851.0
2019-11-14 09:30:00	QQQ	ETF	200.83	201.23	200.7568	201.1	1674222.0
2019-11-14 10:00:00	QQQ	ETF	201.1	201.39	201.04	201.07	858341.0
2019-11-14 10:30:00	QQQ	ETF	201.075	201.13	200.6	200.6	723592.0
2019-11-14 11:00:00	QQQ	ETF	200.59	201.08	200.5461	200.97	768695.0
2019-11-14 11:30:00	QQQ	ETF	200.98	201.02	200.22	200.41	1027747.0
2019-11-14 12:00:00	QQQ	ETF	200.4	200.75	200.335	200.75	861115.0
2019-11-14 12:30:00	QQQ	ETF	200.75	201.07	200.74	201.02	766703.0

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

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