PREVIEW / etf_30min / 2019-12-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-09.parquet
  size:    507 KB
  rows:    17,583

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-12-09 04:00:00	SPY	ETF	314.56	314.63	314.3	314.4	4789.0
2019-12-09 04:30:00	SPY	ETF	314.46	314.59	314.46	314.59	2900.0
2019-12-09 05:00:00	SPY	ETF	314.53	314.66	314.51	314.66	2660.0
2019-12-09 05:30:00	SPY	ETF	314.65	314.75	314.58	314.75	3962.0
2019-12-09 06:00:00	SPY	ETF	314.7	314.7	314.5	314.61	2420.0
2019-12-09 06:30:00	SPY	ETF	314.61	314.61	314.4	314.41	4264.0
2019-12-09 07:00:00	SPY	ETF	314.44	314.64	314.44	314.63	17900.0
2019-12-09 07:30:00	SPY	ETF	314.69	314.71	314.6	314.6	22188.0
2019-12-09 08:00:00	SPY	ETF	314.6	314.7	314.38	314.56	37990.0
2019-12-09 08:30:00	SPY	ETF	314.56	314.59	314.44	314.53	58216.0
2019-12-09 09:00:00	SPY	ETF	314.49	314.55	314.38	314.39	77977.0
2019-12-09 09:30:00	SPY	ETF	314.44	315.12	314.4	314.95	3132608.0
2019-12-09 10:00:00	SPY	ETF	314.96	315.18	314.95	314.97	1830603.0
2019-12-09 10:30:00	SPY	ETF	314.9799	315.13	314.86	315.0198	1734789.0
2019-12-09 11:00:00	SPY	ETF	315.02	315.02	314.64	314.79	2111411.0
2019-12-09 11:30:00	SPY	ETF	314.78	314.8	314.56	314.59	1409494.0
2019-12-09 12:00:00	SPY	ETF	314.59	314.71	314.45	314.55	1384067.0
2019-12-09 12:30:00	SPY	ETF	314.5414	314.61	314.325	314.525	1853267.0
2019-12-09 13:00:00	SPY	ETF	314.525	314.575	314.31	314.4	1638275.0
2019-12-09 13:30:00	SPY	ETF	314.39	314.54	314.33	314.4339	1478667.0
2019-12-09 14:00:00	SPY	ETF	314.4367	314.46	313.94	314.14	2916653.0
2019-12-09 14:30:00	SPY	ETF	314.14	314.41	314.1	314.3	2263209.0
2019-12-09 15:00:00	SPY	ETF	314.31	314.45	314.19	314.392	2172553.0
2019-12-09 15:30:00	SPY	ETF	314.39	314.4021	313.8	313.87	5412635.0
2019-12-09 16:00:00	SPY	ETF	313.88	313.9	313.54	313.68	3695321.0
2019-12-09 16:30:00	SPY	ETF	313.68	313.88	313.39	313.53	478339.0
2019-12-09 17:00:00	SPY	ETF	313.5	313.58	313.44	313.5	77060.0
2019-12-09 17:30:00	SPY	ETF	313.47	313.55	313.47	313.55	18596.0
2019-12-09 18:00:00	SPY	ETF	313.55	313.64	313.55	313.58	61065.0
2019-12-09 18:30:00	SPY	ETF	313.61	313.79	313.61	313.64	16269.0
2019-12-09 19:00:00	SPY	ETF	313.75	313.84	313.58	313.63	21458.0
2019-12-09 19:30:00	SPY	ETF	313.65	313.73	313.65	313.65	12074.0
2019-12-09 04:00:00	QQQ	ETF	204.74	204.74	204.55	204.62	6383.0
2019-12-09 04:30:00	QQQ	ETF	204.65	204.7	204.62	204.7	4040.0
2019-12-09 05:00:00	QQQ	ETF	204.74	204.86	204.65	204.85	7251.0
2019-12-09 05:30:00	QQQ	ETF	204.82	204.83	204.74	204.83	9953.0
2019-12-09 06:00:00	QQQ	ETF	204.84	204.84	204.69	204.7	8560.0
2019-12-09 06:30:00	QQQ	ETF	204.75	204.85	204.59	204.67	8300.0
2019-12-09 07:00:00	QQQ	ETF	204.67	204.84	204.66	204.84	11995.0
2019-12-09 07:30:00	QQQ	ETF	204.82	204.85	204.77	204.77	9980.0
2019-12-09 08:00:00	QQQ	ETF	204.77	204.8	204.68	204.68	29938.0
2019-12-09 08:30:00	QQQ	ETF	204.69	204.7	204.57	204.63	38169.0
2019-12-09 09:00:00	QQQ	ETF	204.64	204.65	204.51	204.59	59210.0
2019-12-09 09:30:00	QQQ	ETF	204.63	205.5937	204.63	205.39	1631801.0
2019-12-09 10:00:00	QQQ	ETF	205.395	205.52	205.27	205.3136	694643.0
2019-12-09 10:30:00	QQQ	ETF	205.29	205.39	205.1231	205.24	582815.0
2019-12-09 11:00:00	QQQ	ETF	205.245	205.25	204.77	204.94	637336.0
2019-12-09 11:30:00	QQQ	ETF	204.93	204.95	204.72	204.8	524276.0
2019-12-09 12:00:00	QQQ	ETF	204.81	204.9	204.64	204.69	470715.0
2019-12-09 12:30:00	QQQ	ETF	204.69	204.75	204.55	204.69	725274.0

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

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