PREVIEW / etf_30min / 2019-12-31

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-31.parquet
  size:    535 KB
  rows:    18,987

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-31 04:00:00	SPY	ETF	321.42	321.43	321.4	321.43	4050.0
2019-12-31 04:30:00	SPY	ETF	321.44	321.44	321.37	321.4	2500.0
2019-12-31 05:00:00	SPY	ETF	321.4	321.51	321.35	321.51	2115.0
2019-12-31 05:30:00	SPY	ETF	321.6	321.65	321.56	321.6	2000.0
2019-12-31 06:00:00	SPY	ETF	321.6	321.6	321.34	321.34	2601.0
2019-12-31 06:30:00	SPY	ETF	321.39	321.39	321.2	321.23	5154.0
2019-12-31 07:00:00	SPY	ETF	321.3	321.3	320.9	321.06	51441.0
2019-12-31 07:30:00	SPY	ETF	321.11	321.15	320.86	320.9	107788.0
2019-12-31 08:00:00	SPY	ETF	320.9	321.39	320.8	321.1	88106.0
2019-12-31 08:30:00	SPY	ETF	321.11	321.11	320.55	320.59	137364.0
2019-12-31 09:00:00	SPY	ETF	320.61	320.67	320.39	320.53	224061.0
2019-12-31 09:30:00	SPY	ETF	320.53	321.54	320.15	321.28	4075243.0
2019-12-31 10:00:00	SPY	ETF	321.28	321.35	320.775	320.78	2413602.0
2019-12-31 10:30:00	SPY	ETF	320.7795	320.87	320.41	320.42	2484243.0
2019-12-31 11:00:00	SPY	ETF	320.41	320.73	320.39	320.5065	2170767.0
2019-12-31 11:30:00	SPY	ETF	320.51	320.88	320.302	320.61	1515095.0
2019-12-31 12:00:00	SPY	ETF	320.61	320.74	320.41	320.66	1827616.0
2019-12-31 12:30:00	SPY	ETF	320.65	320.77	320.58	320.67	1266202.0
2019-12-31 13:00:00	SPY	ETF	320.67	320.82	320.655	320.725	1072554.0
2019-12-31 13:30:00	SPY	ETF	320.72	320.94	320.72	320.92	1953652.0
2019-12-31 14:00:00	SPY	ETF	320.92	321.03	320.74	321.02	1572925.0
2019-12-31 14:30:00	SPY	ETF	321.025	321.09	320.88	320.94	1935154.0
2019-12-31 15:00:00	SPY	ETF	320.94	321.4	320.89	321.4	3981862.0
2019-12-31 15:30:00	SPY	ETF	321.4	322.13	321.36	321.89	11865341.0
2019-12-31 16:00:00	SPY	ETF	321.87	322.39	321.0754	321.86	15887384.0
2019-12-31 16:30:00	SPY	ETF	322.31	322.43	321.86	322.39	453641.0
2019-12-31 17:00:00	SPY	ETF	322.36	322.4	322.31	322.36	67873.0
2019-12-31 17:30:00	SPY	ETF	322.36	322.36	322.22	322.23	80027.0
2019-12-31 18:00:00	SPY	ETF	322.23	322.34	322.22	322.32	19764.0
2019-12-31 18:30:00	SPY	ETF	322.32	322.35	322.32	322.32	4446.0
2019-12-31 19:00:00	SPY	ETF	322.36	322.39	322.33	322.39	6693.0
2019-12-31 19:30:00	SPY	ETF	322.39	322.43	322.35	322.35	14989.0
2019-12-31 04:00:00	QQQ	ETF	212.39	212.42	212.36	212.36	4200.0
2019-12-31 04:30:00	QQQ	ETF	212.36	212.37	212.35	212.36	1402.0
2019-12-31 05:00:00	QQQ	ETF	212.42	212.42	212.42	212.42	700.0
2019-12-31 05:30:00	QQQ	ETF	212.41	212.45	212.41	212.43	600.0
2019-12-31 06:00:00	QQQ	ETF	212.32	212.35	212.32	212.35	1100.0
2019-12-31 06:30:00	QQQ	ETF	212.31	212.31	212.15	212.19	4550.0
2019-12-31 07:00:00	QQQ	ETF	212.22	212.26	211.9	212.14	70750.0
2019-12-31 07:30:00	QQQ	ETF	212.12	212.13	211.91	211.92	37700.0
2019-12-31 08:00:00	QQQ	ETF	211.91	212.6	211.87	212.03	59423.0
2019-12-31 08:30:00	QQQ	ETF	212.04	212.04	211.6	211.68	154630.0
2019-12-31 09:00:00	QQQ	ETF	211.64	211.73	211.52	211.6	151357.0
2019-12-31 09:30:00	QQQ	ETF	211.62	212.52	211.2	212.28	3128763.0
2019-12-31 10:00:00	QQQ	ETF	212.285	212.39	211.77	211.82	1314357.0
2019-12-31 10:30:00	QQQ	ETF	211.82	211.9741	211.6	211.668	881690.0
2019-12-31 11:00:00	QQQ	ETF	211.66	211.94	211.6347	211.68	986314.0
2019-12-31 11:30:00	QQQ	ETF	211.67	212.03	211.51	211.88	882011.0
2019-12-31 12:00:00	QQQ	ETF	211.885	211.98	211.75	211.92	517268.0
2019-12-31 12:30:00	QQQ	ETF	211.91	212.02	211.88	211.94	497310.0

> showing 50 of 18,987 rows — these rows as CSV

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