PREVIEW / etf_30min / 2020-09-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-09-23.parquet
  size:    562 KB
  rows:    20,724

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-09-23 04:00:00	SPY	ETF	330.9	331.16	330.67	331.12	12104.0
2020-09-23 04:30:00	SPY	ETF	331.25	331.58	331.25	331.58	29653.0
2020-09-23 05:00:00	SPY	ETF	331.55	331.68	331.38	331.49	19943.0
2020-09-23 05:30:00	SPY	ETF	331.55	331.88	331.4	331.87	17969.0
2020-09-23 06:00:00	SPY	ETF	331.8	331.82	331.32	331.42	15965.0
2020-09-23 06:30:00	SPY	ETF	331.41	331.93	331.3	331.7	76415.0
2020-09-23 07:00:00	SPY	ETF	331.71	331.75	331.04	331.17	77875.0
2020-09-23 07:30:00	SPY	ETF	331.18	331.62	330.81	330.81	133380.0
2020-09-23 08:00:00	SPY	ETF	331.0301	331.7904	330.15	330.91	175052.0
2020-09-23 08:30:00	SPY	ETF	330.9299	331.17	330.39	330.66	200292.0
2020-09-23 09:00:00	SPY	ETF	330.61	330.94	330.51	330.91	135121.0
2020-09-23 09:30:00	SPY	ETF	330.9	331.2	329.7	329.83	5496598.0
2020-09-23 10:00:00	SPY	ETF	329.815	330.25	328.9	329.61	3635242.0
2020-09-23 10:30:00	SPY	ETF	329.61	329.84	328.51	329.08	3795275.0
2020-09-23 11:00:00	SPY	ETF	329.08	329.665	328.38	328.6199	3647376.0
2020-09-23 11:30:00	SPY	ETF	328.6	328.84	327.44	327.51	3962868.0
2020-09-23 12:00:00	SPY	ETF	327.51	328.209	327.12	327.9036	3079216.0
2020-09-23 12:30:00	SPY	ETF	327.9	328.67	327.64	328.66	2546151.0
2020-09-23 13:00:00	SPY	ETF	328.65	328.729	327.81	327.865	2516544.0
2020-09-23 13:30:00	SPY	ETF	327.87	328.01	326.645	326.9905	3873423.0
2020-09-23 14:00:00	SPY	ETF	327.0	327.01	324.61	324.89	6873130.0
2020-09-23 14:30:00	SPY	ETF	324.89	325.24	323.44	323.64	8181625.0
2020-09-23 15:00:00	SPY	ETF	323.63	324.0199	322.512	323.6499	11162867.0
2020-09-23 15:30:00	SPY	ETF	323.64	324.01	322.1	322.66	19419126.0
2020-09-23 16:00:00	SPY	ETF	322.66	323.19	322.52	323.08	8896067.0
2020-09-23 16:30:00	SPY	ETF	323.08	323.22	322.64	323.1	870502.0
2020-09-23 17:00:00	SPY	ETF	323.06	323.12	322.64	322.8	263708.0
2020-09-23 17:30:00	SPY	ETF	322.8	322.92	322.5	322.78	222903.0
2020-09-23 18:00:00	SPY	ETF	322.78	323.49	322.78	323.39	175171.0
2020-09-23 18:30:00	SPY	ETF	323.39	323.43	322.57	322.72	80041.0
2020-09-23 19:00:00	SPY	ETF	322.93	323.0	321.04	321.11	298042.0
2020-09-23 19:30:00	SPY	ETF	321.14	322.0	321.1	321.7	144763.0
2020-09-23 04:00:00	QQQ	ETF	272.18	272.63	272.18	272.63	44405.0
2020-09-23 04:30:00	QQQ	ETF	272.68	273.2	272.68	273.19	24326.0
2020-09-23 05:00:00	QQQ	ETF	273.2	273.55	273.15	273.32	42269.0
2020-09-23 05:30:00	QQQ	ETF	273.35	273.83	273.23	273.83	8385.0
2020-09-23 06:00:00	QQQ	ETF	273.75	273.75	272.92	273.15	21676.0
2020-09-23 06:30:00	QQQ	ETF	273.02	273.53	272.73	273.23	39630.0
2020-09-23 07:00:00	QQQ	ETF	273.35	273.35	272.21	272.43	107772.0
2020-09-23 07:30:00	QQQ	ETF	272.43	272.75	271.5	271.63	163402.0
2020-09-23 08:00:00	QQQ	ETF	271.63	273.36	271.23	271.89	240884.0
2020-09-23 08:30:00	QQQ	ETF	271.93	272.96	271.34	271.82	408684.0
2020-09-23 09:00:00	QQQ	ETF	271.84	272.21	271.62	272.14	206411.0
2020-09-23 09:30:00	QQQ	ETF	272.15	272.34	270.2	270.38	3202033.0
2020-09-23 10:00:00	QQQ	ETF	270.38	270.9773	269.2	270.22	3430993.0
2020-09-23 10:30:00	QQQ	ETF	270.2155	270.9	269.43	270.03	2178141.0
2020-09-23 11:00:00	QQQ	ETF	270.01	270.65	269.3189	269.598	1550976.0
2020-09-23 11:30:00	QQQ	ETF	269.48	269.75	268.05	268.16	2549076.0
2020-09-23 12:00:00	QQQ	ETF	268.14	269.01	267.75	268.515	2030713.0
2020-09-23 12:30:00	QQQ	ETF	268.51	269.56	268.16	269.48	1543559.0

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

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