PREVIEW / etf_30min / 2019-09-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-23.parquet
  size:    500 KB
  rows:    17,411

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-09-23 04:00:00	SPY	ETF	298.22	298.22	297.41	297.69	36417.0
2019-09-23 04:30:00	SPY	ETF	297.54	297.54	297.16	297.24	21081.0
2019-09-23 05:00:00	SPY	ETF	297.25	297.59	297.25	297.55	16865.0
2019-09-23 05:30:00	SPY	ETF	297.5	298.0	297.5	297.89	24555.0
2019-09-23 06:00:00	SPY	ETF	297.92	297.97	297.79	297.92	8903.0
2019-09-23 06:30:00	SPY	ETF	297.97	298.14	297.81	298.07	21017.0
2019-09-23 07:00:00	SPY	ETF	298.05	298.14	297.98	298.1	40032.0
2019-09-23 07:30:00	SPY	ETF	298.09	298.1	297.8	297.82	86564.0
2019-09-23 08:00:00	SPY	ETF	298.0501	299.4	297.68	297.73	363524.0
2019-09-23 08:30:00	SPY	ETF	297.7	297.92	297.55	297.92	419689.0
2019-09-23 09:00:00	SPY	ETF	297.92	298.1	297.42	297.55	282637.0
2019-09-23 09:30:00	SPY	ETF	297.55	298.39	297.27	298.05	7041550.0
2019-09-23 10:00:00	SPY	ETF	298.06	298.0829	297.44	298.02	3761520.0
2019-09-23 10:30:00	SPY	ETF	298.03	298.17	297.6	297.6875	1828194.0
2019-09-23 11:00:00	SPY	ETF	297.705	298.31	297.68	298.2929	2430403.0
2019-09-23 11:30:00	SPY	ETF	298.29	298.59	298.281	298.435	1781640.0
2019-09-23 12:00:00	SPY	ETF	298.44	298.71	298.33	298.58	1206498.0
2019-09-23 12:30:00	SPY	ETF	298.58	298.7	298.3	298.4461	1821463.0
2019-09-23 13:00:00	SPY	ETF	298.45	298.68	298.37	298.64	1340409.0
2019-09-23 13:30:00	SPY	ETF	298.6416	298.79	298.55	298.72	958122.0
2019-09-23 14:00:00	SPY	ETF	298.72	298.75	298.53	298.58	1346194.0
2019-09-23 14:30:00	SPY	ETF	298.5761	298.69	298.47	298.6	1569699.0
2019-09-23 15:00:00	SPY	ETF	298.6	299.0	298.57	298.87	2818427.0
2019-09-23 15:30:00	SPY	ETF	298.88	298.885	298.18	298.25	6549122.0
2019-09-23 16:00:00	SPY	ETF	298.29	298.7324	298.2	298.55	7023261.0
2019-09-23 16:30:00	SPY	ETF	298.55	299.04	298.54	298.96	3402778.0
2019-09-23 17:00:00	SPY	ETF	298.99	299.04	298.94	298.99	158471.0
2019-09-23 17:30:00	SPY	ETF	298.98	299.01	298.9	298.98	180217.0
2019-09-23 18:00:00	SPY	ETF	299.0	299.15	298.97	299.12	110922.0
2019-09-23 18:30:00	SPY	ETF	299.09	299.16	298.95	299.16	135725.0
2019-09-23 19:00:00	SPY	ETF	299.17	300.01	299.17	299.51	85426.0
2019-09-23 19:30:00	SPY	ETF	299.59	300.0	299.57	299.64	69700.0
2019-09-23 04:00:00	QQQ	ETF	190.54	190.54	189.94	190.19	20560.0
2019-09-23 04:30:00	QQQ	ETF	190.01	190.06	189.88	189.95	9420.0
2019-09-23 05:00:00	QQQ	ETF	189.98	190.22	189.96	190.12	8337.0
2019-09-23 05:30:00	QQQ	ETF	190.25	190.54	190.25	190.46	28292.0
2019-09-23 06:00:00	QQQ	ETF	190.46	190.55	190.46	190.53	1544.0
2019-09-23 06:30:00	QQQ	ETF	190.51	190.66	190.41	190.65	13724.0
2019-09-23 07:00:00	QQQ	ETF	190.58	190.69	190.57	190.67	30427.0
2019-09-23 07:30:00	QQQ	ETF	190.68	190.69	190.38	190.4	36581.0
2019-09-23 08:00:00	QQQ	ETF	190.63	191.55	190.27	190.33	38263.0
2019-09-23 08:30:00	QQQ	ETF	190.32	190.51	190.18	190.51	164942.0
2019-09-23 09:00:00	QQQ	ETF	190.48	190.65	190.07	190.36	112888.0
2019-09-23 09:30:00	QQQ	ETF	190.36	190.69	190.0	190.38	2886793.0
2019-09-23 10:00:00	QQQ	ETF	190.385	190.44	189.72	190.3457	2042833.0
2019-09-23 10:30:00	QQQ	ETF	190.37	190.54	189.84	189.98	1039351.0
2019-09-23 11:00:00	QQQ	ETF	190.0	190.55	189.968	190.53	863488.0
2019-09-23 11:30:00	QQQ	ETF	190.53	190.8	190.52	190.59	1027659.0
2019-09-23 12:00:00	QQQ	ETF	190.61	190.905	190.53	190.769	991650.0
2019-09-23 12:30:00	QQQ	ETF	190.77	190.898	190.51	190.64	577466.0

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

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