PREVIEW / etf_30min / 2020-01-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-27.parquet
  size:    582 KB
  rows:    20,690

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-27 04:00:00	SPY	ETF	325.61	325.61	324.73	324.83	69371.0
2020-01-27 04:30:00	SPY	ETF	324.78	324.88	324.32	324.56	34393.0
2020-01-27 05:00:00	SPY	ETF	324.31	324.48	323.71	324.16	74437.0
2020-01-27 05:30:00	SPY	ETF	324.06	324.13	323.33	323.33	45655.0
2020-01-27 06:00:00	SPY	ETF	323.22	323.97	323.0	323.94	188038.0
2020-01-27 06:30:00	SPY	ETF	323.98	324.21	323.61	323.9	171908.0
2020-01-27 07:00:00	SPY	ETF	323.95	324.69	323.88	324.36	584912.0
2020-01-27 07:30:00	SPY	ETF	324.38	324.49	323.85	323.97	281664.0
2020-01-27 08:00:00	SPY	ETF	324.4	325.8	323.57	323.9	773828.0
2020-01-27 08:30:00	SPY	ETF	323.85	324.01	323.48	323.66	335515.0
2020-01-27 09:00:00	SPY	ETF	323.68	323.72	323.01	323.01	895045.0
2020-01-27 09:30:00	SPY	ETF	323.03	324.69	322.66	324.4875	13031724.0
2020-01-27 10:00:00	SPY	ETF	324.47	324.61	323.55	324.52	5415172.0
2020-01-27 10:30:00	SPY	ETF	324.52	324.62	323.29	323.87	4785420.0
2020-01-27 11:00:00	SPY	ETF	323.86	324.19	323.31	323.79	3392021.0
2020-01-27 11:30:00	SPY	ETF	323.79	324.43	323.5	324.2	4748836.0
2020-01-27 12:00:00	SPY	ETF	324.2	325.03	323.98	324.76	3446658.0
2020-01-27 12:30:00	SPY	ETF	324.75	325.12	324.48	324.69	3142505.0
2020-01-27 13:00:00	SPY	ETF	324.67	325.05	324.44	324.86	2652015.0
2020-01-27 13:30:00	SPY	ETF	324.8625	325.07	324.51	324.6187	2216741.0
2020-01-27 14:00:00	SPY	ETF	324.62	324.91	324.21	324.8946	3181617.0
2020-01-27 14:30:00	SPY	ETF	324.9	324.99	323.89	324.215	4118319.0
2020-01-27 15:00:00	SPY	ETF	324.215	324.55	323.83	324.255	5666604.0
2020-01-27 15:30:00	SPY	ETF	324.25	324.25	323.45	323.52	13017761.0
2020-01-27 16:00:00	SPY	ETF	323.49	328.7677	323.15	323.35	8123618.0
2020-01-27 16:30:00	SPY	ETF	323.35	323.61	323.34	323.51	560906.0
2020-01-27 17:00:00	SPY	ETF	323.52	323.54	323.4	323.44	382419.0
2020-01-27 17:30:00	SPY	ETF	323.44	323.52	323.38	323.42	65727.0
2020-01-27 18:00:00	SPY	ETF	323.37	323.99	323.29	323.94	98228.0
2020-01-27 18:30:00	SPY	ETF	323.95	324.21	323.89	324.03	72576.0
2020-01-27 19:00:00	SPY	ETF	324.03	324.28	324.01	324.05	37392.0
2020-01-27 19:30:00	SPY	ETF	324.07	324.2	323.79	323.92	54392.0
2020-01-27 04:00:00	QQQ	ETF	220.0	220.0	219.18	219.23	88788.0
2020-01-27 04:30:00	QQQ	ETF	219.32	219.32	218.87	219.12	41473.0
2020-01-27 05:00:00	QQQ	ETF	219.1	219.1	218.0	218.39	24628.0
2020-01-27 05:30:00	QQQ	ETF	218.43	218.49	218.0	218.05	51906.0
2020-01-27 06:00:00	QQQ	ETF	217.9	218.52	217.66	218.5	87943.0
2020-01-27 06:30:00	QQQ	ETF	218.54	218.71	218.11	218.39	59401.0
2020-01-27 07:00:00	QQQ	ETF	218.39	219.0	218.35	218.75	237611.0
2020-01-27 07:30:00	QQQ	ETF	218.76	218.87	218.4	218.49	218264.0
2020-01-27 08:00:00	QQQ	ETF	218.52	220.18	218.21	218.68	514617.0
2020-01-27 08:30:00	QQQ	ETF	218.68	218.69	218.27	218.4601	407657.0
2020-01-27 09:00:00	QQQ	ETF	218.45	218.5	217.68	217.71	583300.0
2020-01-27 09:30:00	QQQ	ETF	217.72	218.78	217.18	218.63	7874752.0
2020-01-27 10:00:00	QQQ	ETF	218.62	218.8802	218.02	218.7793	3065957.0
2020-01-27 10:30:00	QQQ	ETF	218.77	218.8299	217.72	218.1245	2293739.0
2020-01-27 11:00:00	QQQ	ETF	218.12	218.37	217.65	218.035	1513063.0
2020-01-27 11:30:00	QQQ	ETF	218.05	218.6	217.88	218.4501	1820572.0
2020-01-27 12:00:00	QQQ	ETF	218.44	219.205	218.2	218.98	1814761.0
2020-01-27 12:30:00	QQQ	ETF	218.97	219.2845	218.82	218.92	1195260.0

> showing 50 of 20,690 rows — these rows as CSV

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