PREVIEW / etf_30min / 2019-08-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-29.parquet
  size:    512 KB
  rows:    17,752

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-08-29 04:00:00	SPY	ETF	290.86	291.01	290.57	290.93	31714.0
2019-08-29 04:30:00	SPY	ETF	290.8	291.18	290.8	290.94	22904.0
2019-08-29 05:00:00	SPY	ETF	291.15	291.67	291.15	291.59	37930.0
2019-08-29 05:30:00	SPY	ETF	291.52	291.76	291.43	291.59	22026.0
2019-08-29 06:00:00	SPY	ETF	291.68	291.96	291.56	291.94	54154.0
2019-08-29 06:30:00	SPY	ETF	291.95	291.98	291.73	291.93	56953.0
2019-08-29 07:00:00	SPY	ETF	291.88	291.97	291.61	291.65	159163.0
2019-08-29 07:30:00	SPY	ETF	291.68	291.94	291.47	291.84	289383.0
2019-08-29 08:00:00	SPY	ETF	291.84	292.02	288.4	291.91	453249.0
2019-08-29 08:30:00	SPY	ETF	291.96	291.99	291.62	291.62	253645.0
2019-08-29 09:00:00	SPY	ETF	291.63	291.76	291.43	291.73	505566.0
2019-08-29 09:30:00	SPY	ETF	291.72	292.6	291.64	292.32	9299052.0
2019-08-29 10:00:00	SPY	ETF	292.32	292.38	291.58	292.01	3897022.0
2019-08-29 10:30:00	SPY	ETF	292.02	292.06	290.61	291.76	5962518.0
2019-08-29 11:00:00	SPY	ETF	291.76	292.3	291.57	292.205	2872052.0
2019-08-29 11:30:00	SPY	ETF	292.2	292.73	292.17	292.525	3155254.0
2019-08-29 12:00:00	SPY	ETF	292.525	292.74	292.34	292.56	2244591.0
2019-08-29 12:30:00	SPY	ETF	292.57	292.91	292.51	292.71	1961424.0
2019-08-29 13:00:00	SPY	ETF	292.72	292.835	292.63	292.65	2105540.0
2019-08-29 13:30:00	SPY	ETF	292.645	293.05	292.5	292.94	1636949.0
2019-08-29 14:00:00	SPY	ETF	292.94	293.16	292.58	292.87	3187882.0
2019-08-29 14:30:00	SPY	ETF	292.875	292.99	292.61	292.68	1457194.0
2019-08-29 15:00:00	SPY	ETF	292.7	292.71	292.24	292.3	2402030.0
2019-08-29 15:30:00	SPY	ETF	292.31	292.83	292.29	292.56	9290763.0
2019-08-29 16:00:00	SPY	ETF	292.57	292.83	292.47	292.67	4561664.0
2019-08-29 16:30:00	SPY	ETF	292.66	292.67	292.48	292.5	256570.0
2019-08-29 17:00:00	SPY	ETF	292.56	292.56	292.47	292.51	8366.0
2019-08-29 17:30:00	SPY	ETF	292.5	292.5362	292.4	292.43	45061.0
2019-08-29 18:00:00	SPY	ETF	292.45	292.76	292.28	292.5	593591.0
2019-08-29 18:30:00	SPY	ETF	292.46	292.5	292.36	292.39	25389.0
2019-08-29 19:00:00	SPY	ETF	292.44	292.49	292.2	292.2	30532.0
2019-08-29 19:30:00	SPY	ETF	292.23	292.47	292.18	292.46	32397.0
2019-08-29 04:00:00	QQQ	ETF	186.78	186.92	186.66	186.87	49124.0
2019-08-29 04:30:00	QQQ	ETF	186.8	187.08	186.77	186.92	68636.0
2019-08-29 05:00:00	QQQ	ETF	186.99	187.51	186.99	187.41	21150.0
2019-08-29 05:30:00	QQQ	ETF	187.33	187.5	187.3	187.4	10654.0
2019-08-29 06:00:00	QQQ	ETF	187.39	187.7	187.36	187.7	27839.0
2019-08-29 06:30:00	QQQ	ETF	187.6	187.77	187.52	187.72	73944.0
2019-08-29 07:00:00	QQQ	ETF	187.69	187.74	187.36	187.39	155676.0
2019-08-29 07:30:00	QQQ	ETF	187.41	187.63	187.3	187.46	207130.0
2019-08-29 08:00:00	QQQ	ETF	187.41	187.79	184.6	187.54	276196.0
2019-08-29 08:30:00	QQQ	ETF	187.59	187.6	187.36	187.4	70430.0
2019-08-29 09:00:00	QQQ	ETF	187.39	187.48	187.25	187.39	166374.0
2019-08-29 09:30:00	QQQ	ETF	187.37	188.34	187.32	188.1099	3507050.0
2019-08-29 10:00:00	QQQ	ETF	188.1	188.13	187.51	187.92	1958016.0
2019-08-29 10:30:00	QQQ	ETF	187.9	187.9412	186.675	187.6103	2580584.0
2019-08-29 11:00:00	QQQ	ETF	187.599	188.06	187.49	187.945	1005909.0
2019-08-29 11:30:00	QQQ	ETF	187.945	188.21	187.9	187.972	883213.0
2019-08-29 12:00:00	QQQ	ETF	187.975	188.2	187.82	188.0286	1125257.0
2019-08-29 12:30:00	QQQ	ETF	188.04	188.26	187.89	188.06	1285623.0

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

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