PREVIEW / etf_30min / 2019-07-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-30.parquet
  size:    495 KB
  rows:    17,399

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-30 04:00:00	SPY	ETF	301.36	301.38	301.17	301.22	13777.0
2019-07-30 04:30:00	SPY	ETF	301.19	301.19	300.8	300.8	5827.0
2019-07-30 05:00:00	SPY	ETF	300.8	300.86	300.57	300.72	31901.0
2019-07-30 05:30:00	SPY	ETF	300.7	300.92	300.56	300.88	28183.0
2019-07-30 06:00:00	SPY	ETF	300.9	300.9	300.53	300.59	5819.0
2019-07-30 06:30:00	SPY	ETF	300.8	300.86	300.64	300.86	9830.0
2019-07-30 07:00:00	SPY	ETF	300.87	300.87	300.4	300.45	129148.0
2019-07-30 07:30:00	SPY	ETF	300.4	300.4	300.04	300.18	183630.0
2019-07-30 08:00:00	SPY	ETF	300.2	301.65	300.07	300.22	243776.0
2019-07-30 08:30:00	SPY	ETF	300.17	300.38	299.75	299.91	345808.0
2019-07-30 09:00:00	SPY	ETF	299.84	300.16	299.81	299.9	320049.0
2019-07-30 09:30:00	SPY	ETF	299.91	300.54	299.49	300.395	6509080.0
2019-07-30 10:00:00	SPY	ETF	300.395	300.72	300.15	300.405	3212182.0
2019-07-30 10:30:00	SPY	ETF	300.405	300.7	300.305	300.57	2504016.0
2019-07-30 11:00:00	SPY	ETF	300.57	300.84	300.5475	300.7	1451616.0
2019-07-30 11:30:00	SPY	ETF	300.7	300.92	300.33	300.37	2604026.0
2019-07-30 12:00:00	SPY	ETF	300.37	300.73	300.31	300.665	1156934.0
2019-07-30 12:30:00	SPY	ETF	300.67	300.77	300.29	300.38	1501607.0
2019-07-30 13:00:00	SPY	ETF	300.39	300.52	300.3335	300.43	1113186.0
2019-07-30 13:30:00	SPY	ETF	300.42	300.74	300.41	300.66	1736128.0
2019-07-30 14:00:00	SPY	ETF	300.66	301.17	300.655	301.035	2964317.0
2019-07-30 14:30:00	SPY	ETF	301.04	301.06	300.76	300.8	1621844.0
2019-07-30 15:00:00	SPY	ETF	300.81	300.94	300.48	300.5	2759848.0
2019-07-30 15:30:00	SPY	ETF	300.505	300.82	300.4	300.82	9303876.0
2019-07-30 16:00:00	SPY	ETF	300.82	300.82	300.55	300.6	3918495.0
2019-07-30 16:30:00	SPY	ETF	300.6	300.9	300.48	300.84	425347.0
2019-07-30 17:00:00	SPY	ETF	300.88	300.89	300.77	300.83	268025.0
2019-07-30 17:30:00	SPY	ETF	300.84	300.96	300.72	300.92	149007.0
2019-07-30 18:00:00	SPY	ETF	300.92	300.99	300.85	300.95	176148.0
2019-07-30 18:30:00	SPY	ETF	300.94	300.95	300.88	300.89	3091.0
2019-07-30 19:00:00	SPY	ETF	300.9	300.95	300.88	300.88	2259.0
2019-07-30 19:30:00	SPY	ETF	300.88	300.96	300.75	300.91	31648.0
2019-07-30 04:00:00	QQQ	ETF	194.44	194.48	194.32	194.32	9340.0
2019-07-30 04:30:00	QQQ	ETF	194.21	194.25	193.95	193.95	13957.0
2019-07-30 05:00:00	QQQ	ETF	193.9	193.97	193.8	193.81	17210.0
2019-07-30 05:30:00	QQQ	ETF	193.84	193.96	193.81	193.92	8230.0
2019-07-30 06:00:00	QQQ	ETF	193.97	193.99	193.69	193.85	11910.0
2019-07-30 06:30:00	QQQ	ETF	193.91	193.94	193.76	193.9	18930.0
2019-07-30 07:00:00	QQQ	ETF	193.93	193.93	193.48	193.48	100363.0
2019-07-30 07:30:00	QQQ	ETF	193.46	193.46	193.11	193.3	107338.0
2019-07-30 08:00:00	QQQ	ETF	193.29	194.88	193.15	193.33	93322.0
2019-07-30 08:30:00	QQQ	ETF	193.37	193.46	192.88	193.07	189382.0
2019-07-30 09:00:00	QQQ	ETF	193.05	193.3	192.99	193.16	180851.0
2019-07-30 09:30:00	QQQ	ETF	193.16	193.88	192.99	193.6	2827382.0
2019-07-30 10:00:00	QQQ	ETF	193.6	194.04	193.51	193.72	2105717.0
2019-07-30 10:30:00	QQQ	ETF	193.72	193.94	193.59	193.74	881948.0
2019-07-30 11:00:00	QQQ	ETF	193.76	194.0	193.72	193.82	719184.0
2019-07-30 11:30:00	QQQ	ETF	193.83	194.05	193.53	193.58	953443.0
2019-07-30 12:00:00	QQQ	ETF	193.58	193.85	193.53	193.76	522242.0
2019-07-30 12:30:00	QQQ	ETF	193.78	193.88	193.58	193.65	433518.0

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

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