PREVIEW / etf_30min / 2020-01-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-16.parquet
  size:    538 KB
  rows:    18,944

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-16 04:00:00	SPY	ETF	329.63	329.72	329.4	329.4	9405.0
2020-01-16 04:30:00	SPY	ETF	329.42	329.51	329.33	329.41	8621.0
2020-01-16 05:00:00	SPY	ETF	329.43	329.51	329.39	329.39	7277.0
2020-01-16 05:30:00	SPY	ETF	329.51	329.58	329.49	329.57	2594.0
2020-01-16 06:00:00	SPY	ETF	329.63	329.65	329.34	329.58	16647.0
2020-01-16 06:30:00	SPY	ETF	329.54	329.7	329.5	329.69	7893.0
2020-01-16 07:00:00	SPY	ETF	329.69	329.72	329.59	329.59	65569.0
2020-01-16 07:30:00	SPY	ETF	329.56	329.67	329.43	329.45	141971.0
2020-01-16 08:00:00	SPY	ETF	329.61	329.72	329.11	329.5	151786.0
2020-01-16 08:30:00	SPY	ETF	329.55	329.68	329.51	329.58	112214.0
2020-01-16 09:00:00	SPY	ETF	329.59	329.74	329.55	329.67	165442.0
2020-01-16 09:30:00	SPY	ETF	329.7	329.99	329.46	329.68	5314926.0
2020-01-16 10:00:00	SPY	ETF	329.67	329.94	329.51	329.81	2816488.0
2020-01-16 10:30:00	SPY	ETF	329.83	330.03	329.61	329.69	3430367.0
2020-01-16 11:00:00	SPY	ETF	329.695	329.91	329.45	329.68	3487095.0
2020-01-16 11:30:00	SPY	ETF	329.69	329.92	329.57	329.835	2025724.0
2020-01-16 12:00:00	SPY	ETF	329.84	329.97	329.75	329.76	1484752.0
2020-01-16 12:30:00	SPY	ETF	329.76	330.0	329.74	329.89	1020278.0
2020-01-16 13:00:00	SPY	ETF	329.9	329.9825	329.82	329.88	1148501.0
2020-01-16 13:30:00	SPY	ETF	329.885	330.14	329.81	330.08	2201430.0
2020-01-16 14:00:00	SPY	ETF	330.08	330.14	329.98	330.07	1950873.0
2020-01-16 14:30:00	SPY	ETF	330.08	330.09	329.89	329.97	1975662.0
2020-01-16 15:00:00	SPY	ETF	329.97	330.235	329.92	330.18	3405818.0
2020-01-16 15:30:00	SPY	ETF	330.18	330.91	330.175	330.9	11388809.0
2020-01-16 16:00:00	SPY	ETF	330.9	330.93	330.622	330.81	5664639.0
2020-01-16 16:30:00	SPY	ETF	330.81	330.93	330.81	330.85	488322.0
2020-01-16 17:00:00	SPY	ETF	330.84	330.92	330.74	330.85	67884.0
2020-01-16 17:30:00	SPY	ETF	330.87	330.91	330.79	330.85	1019424.0
2020-01-16 18:00:00	SPY	ETF	330.85	331.43	330.81	331.16	208206.0
2020-01-16 18:30:00	SPY	ETF	331.12	331.19	331.11	331.12	4263.0
2020-01-16 19:00:00	SPY	ETF	331.11	331.12	331.0	331.05	12164.0
2020-01-16 19:30:00	SPY	ETF	331.1	331.14	331.07	331.13	33804.0
2020-01-16 04:00:00	QQQ	ETF	221.36	221.4	221.09	221.12	11574.0
2020-01-16 04:30:00	QQQ	ETF	221.18	221.22	221.04	221.14	11301.0
2020-01-16 05:00:00	QQQ	ETF	221.11	221.22	221.04	221.17	6185.0
2020-01-16 05:30:00	QQQ	ETF	221.18	221.33	221.18	221.33	3500.0
2020-01-16 06:00:00	QQQ	ETF	221.28	221.28	221.07	221.24	8350.0
2020-01-16 06:30:00	QQQ	ETF	221.25	221.34	221.15	221.31	11556.0
2020-01-16 07:00:00	QQQ	ETF	221.31	221.4	221.21	221.22	35401.0
2020-01-16 07:30:00	QQQ	ETF	221.24	221.33	221.12	221.15	85266.0
2020-01-16 08:00:00	QQQ	ETF	221.32	221.5	220.17	221.16	63810.0
2020-01-16 08:30:00	QQQ	ETF	221.17	221.34	221.1598	221.2	170892.0
2020-01-16 09:00:00	QQQ	ETF	221.2	221.3	221.16	221.26	50166.0
2020-01-16 09:30:00	QQQ	ETF	221.26	221.79	221.07	221.6	2283872.0
2020-01-16 10:00:00	QQQ	ETF	221.58	221.83	221.37	221.49	1148995.0
2020-01-16 10:30:00	QQQ	ETF	221.52	221.57	221.11	221.16	1219338.0
2020-01-16 11:00:00	QQQ	ETF	221.18	221.41	220.8	221.0925	1119068.0
2020-01-16 11:30:00	QQQ	ETF	221.1	221.29	220.9305	221.2201	574877.0
2020-01-16 12:00:00	QQQ	ETF	221.22	221.33	221.14	221.1474	458344.0
2020-01-16 12:30:00	QQQ	ETF	221.15	221.31	221.13	221.19	494629.0

> showing 50 of 18,944 rows — these rows as CSV

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