PREVIEW / etf_30min / 2020-01-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-08.parquet
  size:    561 KB
  rows:    19,635

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-08 04:00:00	SPY	ETF	322.08	322.44	322.03	322.1	47114.0
2020-01-08 04:30:00	SPY	ETF	322.06	322.44	322.05	322.42	25307.0
2020-01-08 05:00:00	SPY	ETF	322.3	322.81	322.2	322.57	34213.0
2020-01-08 05:30:00	SPY	ETF	322.66	323.33	322.65	323.21	65608.0
2020-01-08 06:00:00	SPY	ETF	323.26	323.65	323.0	323.56	68671.0
2020-01-08 06:30:00	SPY	ETF	323.55	323.64	323.07	323.12	246784.0
2020-01-08 07:00:00	SPY	ETF	323.09	323.34	323.01	323.03	268265.0
2020-01-08 07:30:00	SPY	ETF	323.04	323.46	322.91	323.35	324984.0
2020-01-08 08:00:00	SPY	ETF	323.31	323.68	320.89	323.46	665670.0
2020-01-08 08:30:00	SPY	ETF	323.48	323.56	322.85	323.03	275667.0
2020-01-08 09:00:00	SPY	ETF	323.03	323.18	322.95	322.95	260300.0
2020-01-08 09:30:00	SPY	ETF	322.94	323.85	322.67	323.71	4344997.0
2020-01-08 10:00:00	SPY	ETF	323.73	323.98	323.37	323.41	3594385.0
2020-01-08 10:30:00	SPY	ETF	323.41	323.5	322.88	323.295	2286583.0
2020-01-08 11:00:00	SPY	ETF	323.31	324.26	323.1	324.03	4016626.0
2020-01-08 11:30:00	SPY	ETF	324.03	325.22	323.48	324.81	7664658.0
2020-01-08 12:00:00	SPY	ETF	324.81	325.0799	324.71	324.98	2675418.0
2020-01-08 12:30:00	SPY	ETF	324.98	325.05	324.7399	324.89	1690081.0
2020-01-08 13:00:00	SPY	ETF	324.89	324.97	324.63	324.82	1907063.0
2020-01-08 13:30:00	SPY	ETF	324.83	324.97	324.56	324.61	2220991.0
2020-01-08 14:00:00	SPY	ETF	324.63	325.01	324.63	324.89	2767812.0
2020-01-08 14:30:00	SPY	ETF	324.9	325.26	324.76	325.25	3265792.0
2020-01-08 15:00:00	SPY	ETF	325.255	325.78	325.22	325.695	4904892.0
2020-01-08 15:30:00	SPY	ETF	325.7	325.755	324.23	324.42	15242516.0
2020-01-08 16:00:00	SPY	ETF	324.41	325.14	324.34	324.95	7081751.0
2020-01-08 16:30:00	SPY	ETF	324.95	325.13	322.7855	324.97	888437.0
2020-01-08 17:00:00	SPY	ETF	324.99	325.08	324.96	325.08	156258.0
2020-01-08 17:30:00	SPY	ETF	325.08	325.15	325.03	325.08	61884.0
2020-01-08 18:00:00	SPY	ETF	325.07	325.45	325.04	325.43	150980.0
2020-01-08 18:30:00	SPY	ETF	325.32	325.32	324.95	325.2	26444.0
2020-01-08 19:00:00	SPY	ETF	325.22	325.52	324.93	325.2	26399.0
2020-01-08 19:30:00	SPY	ETF	325.25	325.36	325.21	325.36	31399.0
2020-01-08 20:00:00	SPY	ETF	325.37	325.37	325.37	325.37	300.0
2020-01-08 04:00:00	QQQ	ETF	214.78	215.09	214.74	214.8	83125.0
2020-01-08 04:30:00	QQQ	ETF	214.74	215.06	214.72	214.94	33891.0
2020-01-08 05:00:00	QQQ	ETF	214.88	215.32	214.88	215.17	11115.0
2020-01-08 05:30:00	QQQ	ETF	215.22	215.78	215.22	215.61	21110.0
2020-01-08 06:00:00	QQQ	ETF	215.58	215.97	215.46	215.92	21607.0
2020-01-08 06:30:00	QQQ	ETF	215.93	215.98	215.62	215.63	71026.0
2020-01-08 07:00:00	QQQ	ETF	215.64	215.75	215.53	215.56	154371.0
2020-01-08 07:30:00	QQQ	ETF	215.53	215.94	215.5	215.8	216361.0
2020-01-08 08:00:00	QQQ	ETF	215.59	216.14	214.06	215.94	296368.0
2020-01-08 08:30:00	QQQ	ETF	215.95	216.02	215.41	215.63	250747.0
2020-01-08 09:00:00	QQQ	ETF	215.63	215.73	215.43	215.47	124250.0
2020-01-08 09:30:00	QQQ	ETF	215.47	216.32	215.16	216.17	2445474.0
2020-01-08 10:00:00	QQQ	ETF	216.22	216.36	215.95	216.02	1313000.0
2020-01-08 10:30:00	QQQ	ETF	216.01	216.15	215.39	215.7307	1062670.0
2020-01-08 11:00:00	QQQ	ETF	215.74	216.57	215.51	216.37	1526148.0
2020-01-08 11:30:00	QQQ	ETF	216.37	217.33	215.97	217.05	2737286.0
2020-01-08 12:00:00	QQQ	ETF	217.05	217.41	217.03	217.33	894642.0

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

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