PREVIEW / etf_30min / 2018-12-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-19.parquet
  size:    527 KB
  rows:    18,334

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
2018-12-19 04:00:00	SPY	ETF	255.46	255.82	255.46	255.76	24681.0
2018-12-19 04:30:00	SPY	ETF	255.7	255.97	255.62	255.97	28229.0
2018-12-19 05:00:00	SPY	ETF	255.93	256.37	255.93	256.21	50268.0
2018-12-19 05:30:00	SPY	ETF	256.19	256.23	256.03	256.14	24511.0
2018-12-19 06:00:00	SPY	ETF	256.11	256.22	255.98	256.04	91320.0
2018-12-19 06:30:00	SPY	ETF	256.09	256.13	255.95	256.13	35297.0
2018-12-19 07:00:00	SPY	ETF	256.13	256.51	256.1	256.27	192534.0
2018-12-19 07:30:00	SPY	ETF	256.25	256.26	256.09	256.2	219905.0
2018-12-19 08:00:00	SPY	ETF	256.18	256.45	255.38	255.75	240941.0
2018-12-19 08:30:00	SPY	ETF	255.72	255.78	255.44	255.56	165875.0
2018-12-19 09:00:00	SPY	ETF	255.56	255.6	255.15	255.18	503131.0
2018-12-19 09:30:00	SPY	ETF	255.17	257.42	254.95	256.91	10535074.0
2018-12-19 10:00:00	SPY	ETF	256.91	257.56	256.87	257.39	8983447.0
2018-12-19 10:30:00	SPY	ETF	257.39	257.75	257.1	257.64	6339029.0
2018-12-19 11:00:00	SPY	ETF	257.63	257.69	256.55	256.96	7538907.0
2018-12-19 11:30:00	SPY	ETF	256.95	257.68	256.55	257.6075	4732617.0
2018-12-19 12:00:00	SPY	ETF	257.6	258.38	257.52	258.11	5063789.0
2018-12-19 12:30:00	SPY	ETF	258.1167	258.32	257.61	257.64	4461759.0
2018-12-19 13:00:00	SPY	ETF	257.64	257.69	256.76	257.14	4936947.0
2018-12-19 13:30:00	SPY	ETF	257.14	259.12	256.99	258.87	6170415.0
2018-12-19 14:00:00	SPY	ETF	258.87	259.4	253.88	256.32	31638486.0
2018-12-19 14:30:00	SPY	ETF	256.31	257.14	251.55	252.24	29930515.0
2018-12-19 15:00:00	SPY	ETF	252.24	252.27	249.35	250.6299	42507382.0
2018-12-19 15:30:00	SPY	ETF	250.63	251.99	250.07	251.2	32293410.0
2018-12-19 16:00:00	SPY	ETF	251.16	257.5553	250.6442	251.03	12635727.0
2018-12-19 16:30:00	SPY	ETF	251.02	251.26	250.0	250.76	2608052.0
2018-12-19 17:00:00	SPY	ETF	250.7	250.76	250.43	250.45	153255.0
2018-12-19 17:30:00	SPY	ETF	250.48	250.73	250.43	250.71	130590.0
2018-12-19 18:00:00	SPY	ETF	250.71	251.41	250.15	251.36	309816.0
2018-12-19 18:30:00	SPY	ETF	251.33	251.68	251.3	251.44	151751.0
2018-12-19 19:00:00	SPY	ETF	251.46	251.64	251.07	251.34	69651.0
2018-12-19 19:30:00	SPY	ETF	251.26	251.72	251.26	251.57	35721.0
2018-12-19 20:00:00	SPY	ETF	251.26	251.81	251.26	251.81	800.0
2018-12-19 04:00:00	QQQ	ETF	158.5	158.72	158.5	158.62	4010.0
2018-12-19 04:30:00	QQQ	ETF	158.62	158.78	158.59	158.66	5728.0
2018-12-19 05:00:00	QQQ	ETF	158.8	159.2	158.78	159.12	9609.0
2018-12-19 05:30:00	QQQ	ETF	159.06	159.09	158.93	159.06	15013.0
2018-12-19 06:00:00	QQQ	ETF	159.05	159.08	158.97	158.97	7684.0
2018-12-19 06:30:00	QQQ	ETF	158.97	159.09	158.91	159.09	11460.0
2018-12-19 07:00:00	QQQ	ETF	159.06	159.28	159.02	159.18	26684.0
2018-12-19 07:30:00	QQQ	ETF	159.16	159.16	158.96	159.01	57297.0
2018-12-19 08:00:00	QQQ	ETF	159.1299	159.26	158.39	158.62	107035.0
2018-12-19 08:30:00	QQQ	ETF	158.62	158.68	158.41	158.5	55360.0
2018-12-19 09:00:00	QQQ	ETF	158.49	158.61	158.26	158.28	124361.0
2018-12-19 09:30:00	QQQ	ETF	158.24	160.239	157.93	159.92	4535717.0
2018-12-19 10:00:00	QQQ	ETF	159.93	160.34	159.77	160.09	2948005.0
2018-12-19 10:30:00	QQQ	ETF	160.08	160.42	159.79	160.135	2170431.0
2018-12-19 11:00:00	QQQ	ETF	160.14	160.179	159.22	159.46	1656923.0
2018-12-19 11:30:00	QQQ	ETF	159.46	160.093	159.27	160.05	1575534.0
2018-12-19 12:00:00	QQQ	ETF	160.08	160.35	159.98	160.15	1590817.0

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

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