PREVIEW / etf_30min / 2020-01-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-23.parquet
  size:    552 KB
  rows:    19,223

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-23 04:00:00	SPY	ETF	331.05	331.13	330.98	331.08	26452.0
2020-01-23 04:30:00	SPY	ETF	331.15	331.21	331.02	331.12	5301.0
2020-01-23 05:00:00	SPY	ETF	331.09	331.36	331.09	331.36	26128.0
2020-01-23 05:30:00	SPY	ETF	331.31	331.33	331.24	331.3	18712.0
2020-01-23 06:00:00	SPY	ETF	331.31	331.38	331.16	331.2	15769.0
2020-01-23 06:30:00	SPY	ETF	331.2	331.3	331.12	331.25	28583.0
2020-01-23 07:00:00	SPY	ETF	331.25	331.35	331.0	331.04	81834.0
2020-01-23 07:30:00	SPY	ETF	331.02	331.02	330.7	330.8	138506.0
2020-01-23 08:00:00	SPY	ETF	331.3501	331.36	330.52	330.73	226752.0
2020-01-23 08:30:00	SPY	ETF	330.75	331.03	330.57	330.66	421309.0
2020-01-23 09:00:00	SPY	ETF	330.65	330.83	330.35	330.64	177783.0
2020-01-23 09:30:00	SPY	ETF	330.63	330.81	329.41	330.31	7270927.0
2020-01-23 10:00:00	SPY	ETF	330.31	330.61	330.08	330.5037	3363423.0
2020-01-23 10:30:00	SPY	ETF	330.52	330.83	330.1501	330.29	2567176.0
2020-01-23 11:00:00	SPY	ETF	330.27	330.39	329.61	329.68	2517495.0
2020-01-23 11:30:00	SPY	ETF	329.68	330.24	329.6679	330.169	1687916.0
2020-01-23 12:00:00	SPY	ETF	330.16	330.63	330.01	330.59	1516969.0
2020-01-23 12:30:00	SPY	ETF	330.59	330.675	330.27	330.32	1380170.0
2020-01-23 13:00:00	SPY	ETF	330.3101	330.99	330.21	330.62	2398796.0
2020-01-23 13:30:00	SPY	ETF	330.6199	331.21	330.59	331.1979	2220046.0
2020-01-23 14:00:00	SPY	ETF	331.2	331.62	331.14	331.47	3888763.0
2020-01-23 14:30:00	SPY	ETF	331.4799	331.7052	331.37	331.69	2549744.0
2020-01-23 15:00:00	SPY	ETF	331.69	331.85	331.44	331.73	2540246.0
2020-01-23 15:30:00	SPY	ETF	331.73	331.92	331.46	331.74	7923583.0
2020-01-23 16:00:00	SPY	ETF	331.76	331.93	331.3837	331.77	7685512.0
2020-01-23 16:30:00	SPY	ETF	331.79	331.89	331.3837	331.86	287391.0
2020-01-23 17:00:00	SPY	ETF	331.84	331.86	330.7896	331.8	17360.0
2020-01-23 17:30:00	SPY	ETF	331.8	331.87	331.72	331.87	55168.0
2020-01-23 18:00:00	SPY	ETF	331.86	332.37	331.8	332.01	79138.0
2020-01-23 18:30:00	SPY	ETF	332.03	332.25	332.03	332.25	16674.0
2020-01-23 19:00:00	SPY	ETF	332.21	332.28	332.06	332.1	17806.0
2020-01-23 19:30:00	SPY	ETF	332.11	332.19	331.95	331.97	17190.0
2020-01-23 04:00:00	QQQ	ETF	223.7	223.83	223.66	223.73	12894.0
2020-01-23 04:30:00	QQQ	ETF	223.78	223.78	223.68	223.75	2426.0
2020-01-23 05:00:00	QQQ	ETF	223.75	223.98	223.75	223.91	6920.0
2020-01-23 05:30:00	QQQ	ETF	223.93	224.04	223.93	224.04	11700.0
2020-01-23 06:00:00	QQQ	ETF	224.03	224.04	223.93	223.93	3600.0
2020-01-23 06:30:00	QQQ	ETF	223.96	223.99	223.86	223.94	10000.0
2020-01-23 07:00:00	QQQ	ETF	223.96	224.13	223.89	223.95	32755.0
2020-01-23 07:30:00	QQQ	ETF	223.9	223.9	223.7	223.77	65660.0
2020-01-23 08:00:00	QQQ	ETF	224.09	224.1	223.29	223.61	78354.0
2020-01-23 08:30:00	QQQ	ETF	223.61	223.95	223.55	223.64	106398.0
2020-01-23 09:00:00	QQQ	ETF	223.69	223.78	223.45	223.72	79199.0
2020-01-23 09:30:00	QQQ	ETF	223.71	223.9	222.7	223.61	4147249.0
2020-01-23 10:00:00	QQQ	ETF	223.6199	224.04	223.47	223.985	1868013.0
2020-01-23 10:30:00	QQQ	ETF	223.99	224.22	223.51	223.61	1293906.0
2020-01-23 11:00:00	QQQ	ETF	223.62	223.71	223.29	223.31	956424.0
2020-01-23 11:30:00	QQQ	ETF	223.31	223.775	223.2812	223.68	1153048.0
2020-01-23 12:00:00	QQQ	ETF	223.68	223.995	223.53	223.95	775663.0
2020-01-23 12:30:00	QQQ	ETF	223.95	224.015	223.56	223.62	509906.0

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

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