PREVIEW / etf_30min / 2019-05-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-22.parquet
  size:    477 KB
  rows:    16,793

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-05-22 04:00:00	SPY	ETF	285.73	285.95	285.63	285.95	1605.0
2019-05-22 04:30:00	SPY	ETF	286.06	286.06	286.06	286.06	200.0
2019-05-22 05:00:00	SPY	ETF	285.99	286.37	285.99	286.37	1301.0
2019-05-22 05:30:00	SPY	ETF	286.44	286.44	286.26	286.31	12200.0
2019-05-22 06:00:00	SPY	ETF	286.4	286.53	286.4	286.43	2899.0
2019-05-22 06:30:00	SPY	ETF	286.31	286.31	286.07	286.07	27405.0
2019-05-22 07:00:00	SPY	ETF	286.13	286.13	285.72	285.93	145454.0
2019-05-22 07:30:00	SPY	ETF	285.96	285.96	285.2	285.22	284530.0
2019-05-22 08:00:00	SPY	ETF	285.9899	286.68	284.75	285.03	778301.0
2019-05-22 08:30:00	SPY	ETF	285.03	285.47	285.03	285.42	610447.0
2019-05-22 09:00:00	SPY	ETF	285.4	285.5	285.26	285.45	188107.0
2019-05-22 09:30:00	SPY	ETF	285.45	286.02	285.3	285.99	5731422.0
2019-05-22 10:00:00	SPY	ETF	286.0	286.69	285.55	286.07	6368585.0
2019-05-22 10:30:00	SPY	ETF	286.08	286.18	285.38	285.64	2937006.0
2019-05-22 11:00:00	SPY	ETF	285.63	286.13	285.26	286.1	4971024.0
2019-05-22 11:30:00	SPY	ETF	286.095	286.29	285.58	285.8933	2772241.0
2019-05-22 12:00:00	SPY	ETF	285.88	286.04	285.59	285.67	1741423.0
2019-05-22 12:30:00	SPY	ETF	285.66	285.73	285.325	285.46	2150448.0
2019-05-22 13:00:00	SPY	ETF	285.45	285.54	285.1	285.44	3030194.0
2019-05-22 13:30:00	SPY	ETF	285.44	285.99	285.296	285.88	1793782.0
2019-05-22 14:00:00	SPY	ETF	285.88	285.94	285.54	285.865	1948970.0
2019-05-22 14:30:00	SPY	ETF	285.87	286.35	285.87	286.17	2415158.0
2019-05-22 15:00:00	SPY	ETF	286.1751	286.29	285.93	286.05	2017368.0
2019-05-22 15:30:00	SPY	ETF	286.04	286.08	285.62	285.62	5819182.0
2019-05-22 16:00:00	SPY	ETF	285.65	285.8344	285.57	285.6	2361969.0
2019-05-22 16:30:00	SPY	ETF	285.59	285.63	285.45	285.6	588429.0
2019-05-22 17:00:00	SPY	ETF	285.56	285.71	285.55	285.62	111946.0
2019-05-22 17:30:00	SPY	ETF	285.61	285.68	285.57	285.67	17906.0
2019-05-22 18:00:00	SPY	ETF	285.67	285.73	285.65	285.69	15678.0
2019-05-22 18:30:00	SPY	ETF	285.68	285.68	285.6	285.6	18034.0
2019-05-22 19:00:00	SPY	ETF	285.6	285.6	285.24	285.45	43565.0
2019-05-22 19:30:00	SPY	ETF	285.39	285.42	285.26	285.37	13122.0
2019-05-22 04:00:00	QQQ	ETF	181.06	181.34	181.06	181.28	5916.0
2019-05-22 04:30:00	QQQ	ETF	181.25	181.35	181.25	181.25	3149.0
2019-05-22 05:00:00	QQQ	ETF	181.33	181.69	181.33	181.66	7910.0
2019-05-22 05:30:00	QQQ	ETF	181.77	181.81	181.44	181.55	34750.0
2019-05-22 06:00:00	QQQ	ETF	181.58	181.71	181.5	181.69	5900.0
2019-05-22 06:30:00	QQQ	ETF	181.69	181.7	181.29	181.31	25266.0
2019-05-22 07:00:00	QQQ	ETF	181.33	181.33	181.04	181.16	193833.0
2019-05-22 07:30:00	QQQ	ETF	181.14	181.14	180.46	180.6	330233.0
2019-05-22 08:00:00	QQQ	ETF	181.18	181.83	180.09	180.36	538729.0
2019-05-22 08:30:00	QQQ	ETF	180.35	180.8	180.3401	180.68	210117.0
2019-05-22 09:00:00	QQQ	ETF	180.63	180.8	180.58	180.8	75850.0
2019-05-22 09:30:00	QQQ	ETF	180.81	181.57	180.79	181.5	2879378.0
2019-05-22 10:00:00	QQQ	ETF	181.5	182.07	181.17	181.4995	3071680.0
2019-05-22 10:30:00	QQQ	ETF	181.49	181.6394	180.96	181.16	1099908.0
2019-05-22 11:00:00	QQQ	ETF	181.15	181.56	180.84	181.54	1235542.0
2019-05-22 11:30:00	QQQ	ETF	181.54	181.71	181.06	181.37	1120377.0
2019-05-22 12:00:00	QQQ	ETF	181.36	181.46	181.14	181.24	736414.0
2019-05-22 12:30:00	QQQ	ETF	181.22	181.28	180.9	181.1089	677331.0

> showing 50 of 16,793 rows — these rows as CSV

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