PREVIEW / etf_30min / 2019-07-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-29.parquet
  size:    483 KB
  rows:    17,068

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
2019-07-29 04:00:00	SPY	ETF	301.62	301.81	301.62	301.8	1290.0
2019-07-29 04:30:00	SPY	ETF	301.74	301.74	301.67	301.68	3156.0
2019-07-29 05:00:00	SPY	ETF	301.68	301.76	301.63	301.71	7958.0
2019-07-29 05:30:00	SPY	ETF	301.6	301.64	301.6	301.61	1500.0
2019-07-29 06:00:00	SPY	ETF	301.66	301.8	301.66	301.71	7665.0
2019-07-29 06:30:00	SPY	ETF	301.74	301.74	301.53	301.53	3677.0
2019-07-29 07:00:00	SPY	ETF	301.5	301.82	301.5	301.77	46229.0
2019-07-29 07:30:00	SPY	ETF	301.82	302.05	301.82	301.97	38103.0
2019-07-29 08:00:00	SPY	ETF	302.0	302.02	301.36	301.82	487841.0
2019-07-29 08:30:00	SPY	ETF	301.83	301.87	301.8	301.86	203553.0
2019-07-29 09:00:00	SPY	ETF	301.88	301.94	301.79	301.85	187305.0
2019-07-29 09:30:00	SPY	ETF	301.88	301.93	301.07	301.13	5193198.0
2019-07-29 10:00:00	SPY	ETF	301.125	301.28	300.85	301.2	3604404.0
2019-07-29 10:30:00	SPY	ETF	301.195	301.44	301.1	301.28	3693617.0
2019-07-29 11:00:00	SPY	ETF	301.28	301.57	301.17	301.53	1561142.0
2019-07-29 11:30:00	SPY	ETF	301.54	301.69	301.37	301.6	2576972.0
2019-07-29 12:00:00	SPY	ETF	301.61	301.61	301.22	301.43	1296958.0
2019-07-29 12:30:00	SPY	ETF	301.42	301.63	301.255	301.6268	915986.0
2019-07-29 13:00:00	SPY	ETF	301.6273	301.73	301.49	301.59	1831953.0
2019-07-29 13:30:00	SPY	ETF	301.59	301.7	301.45	301.46	939113.0
2019-07-29 14:00:00	SPY	ETF	301.46	301.6	301.33	301.59	1521485.0
2019-07-29 14:30:00	SPY	ETF	301.58	301.62	301.33	301.54	1078265.0
2019-07-29 15:00:00	SPY	ETF	301.53	301.62	301.34	301.41	1455801.0
2019-07-29 15:30:00	SPY	ETF	301.405	301.74	301.3703	301.48	7149034.0
2019-07-29 16:00:00	SPY	ETF	301.48	301.61	301.44	301.5	3173730.0
2019-07-29 16:30:00	SPY	ETF	301.53	301.7	301.47	301.61	194975.0
2019-07-29 17:00:00	SPY	ETF	301.61	301.62	301.59	301.61	3107.0
2019-07-29 17:30:00	SPY	ETF	301.6	301.63	301.46	301.57	57825.0
2019-07-29 18:00:00	SPY	ETF	301.58	301.76	301.46	301.72	34264.0
2019-07-29 18:30:00	SPY	ETF	301.76	301.84	301.72	301.77	32473.0
2019-07-29 19:00:00	SPY	ETF	301.8	301.81	301.76	301.81	6750.0
2019-07-29 19:30:00	SPY	ETF	301.78	301.83	301.76	301.81	9110.0
2019-07-29 04:00:00	QQQ	ETF	195.05	195.11	194.98	195.04	10219.0
2019-07-29 04:30:00	QQQ	ETF	195.03	195.03	194.97	194.98	1780.0
2019-07-29 05:00:00	QQQ	ETF	194.97	195.03	194.91	194.92	3459.0
2019-07-29 05:30:00	QQQ	ETF	194.89	194.95	194.89	194.93	3005.0
2019-07-29 06:00:00	QQQ	ETF	194.96	195.06	194.94	195.03	7775.0
2019-07-29 06:30:00	QQQ	ETF	195.02	195.02	194.87	194.93	3209.0
2019-07-29 07:00:00	QQQ	ETF	194.92	195.17	194.92	195.17	19182.0
2019-07-29 07:30:00	QQQ	ETF	195.19	195.34	195.19	195.26	18110.0
2019-07-29 08:00:00	QQQ	ETF	194.95	195.33	194.95	195.18	26267.0
2019-07-29 08:30:00	QQQ	ETF	195.19	195.25	195.17	195.25	19518.0
2019-07-29 09:00:00	QQQ	ETF	195.25	195.33	195.1	195.16	90515.0
2019-07-29 09:30:00	QQQ	ETF	195.16	195.18	193.76	193.845	3326344.0
2019-07-29 10:00:00	QQQ	ETF	193.84	193.94	193.39	193.795	3082092.0
2019-07-29 10:30:00	QQQ	ETF	193.7783	194.13	193.7	193.9	1865881.0
2019-07-29 11:00:00	QQQ	ETF	193.91	194.2	193.81	194.18	1094995.0
2019-07-29 11:30:00	QQQ	ETF	194.2	194.39	194.0464	194.29	927372.0
2019-07-29 12:00:00	QQQ	ETF	194.29	194.29	193.98	194.18	772754.0
2019-07-29 12:30:00	QQQ	ETF	194.18	194.44	194.08	194.43	654230.0

> showing 50 of 17,068 rows — these rows as CSV

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