PREVIEW / etf_30min / 2018-12-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-06.parquet
  size:    542 KB
  rows:    18,924

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-06 04:00:00	SPY	ETF	267.63	267.63	266.94	266.99	105035.0
2018-12-06 04:30:00	SPY	ETF	267.06	267.13	265.52	265.58	117679.0
2018-12-06 05:00:00	SPY	ETF	265.67	265.83	265.37	265.52	79423.0
2018-12-06 05:30:00	SPY	ETF	265.48	266.1	265.4	265.84	122756.0
2018-12-06 06:00:00	SPY	ETF	265.72	266.49	265.69	266.15	75617.0
2018-12-06 06:30:00	SPY	ETF	266.26	266.3	265.5	265.98	213264.0
2018-12-06 07:00:00	SPY	ETF	265.98	266.67	265.92	266.5	235306.0
2018-12-06 07:30:00	SPY	ETF	266.46	266.73	266.02	266.34	254981.0
2018-12-06 08:00:00	SPY	ETF	266.3201	268.55	265.69	267.03	547580.0
2018-12-06 08:30:00	SPY	ETF	267.0	267.1	266.31	266.33	666191.0
2018-12-06 09:00:00	SPY	ETF	266.36	266.51	265.79	265.93	1044967.0
2018-12-06 09:30:00	SPY	ETF	265.92	267.15	264.62	265.07	20987548.0
2018-12-06 10:00:00	SPY	ETF	265.07	266.13	264.75	265.85	14111350.0
2018-12-06 10:30:00	SPY	ETF	265.86	266.09	264.06	264.27	10527757.0
2018-12-06 11:00:00	SPY	ETF	264.26	264.58	262.44	262.77	13247330.0
2018-12-06 11:30:00	SPY	ETF	262.76	265.02	262.67	264.87	14686226.0
2018-12-06 12:00:00	SPY	ETF	264.86	266.36	264.39	266.24	12043344.0
2018-12-06 12:30:00	SPY	ETF	266.24	267.09	265.74	266.65	10284120.0
2018-12-06 13:00:00	SPY	ETF	266.64	266.65	265.16	265.33	6955316.0
2018-12-06 13:30:00	SPY	ETF	265.33	267.24	264.75	267.2	13097268.0
2018-12-06 14:00:00	SPY	ETF	267.1803	267.639	265.57	266.66	10338431.0
2018-12-06 14:30:00	SPY	ETF	266.66	267.21	265.19	267.0299	10511882.0
2018-12-06 15:00:00	SPY	ETF	267.03	267.81	266.55	267.5	12838664.0
2018-12-06 15:30:00	SPY	ETF	267.51	269.97	267.36	269.93	31097598.0
2018-12-06 16:00:00	SPY	ETF	269.94	270.21	262.85	269.65	14593238.0
2018-12-06 16:30:00	SPY	ETF	269.62	270.3161	269.61	269.83	2515797.0
2018-12-06 17:00:00	SPY	ETF	269.78	269.94	269.75	269.91	76256.0
2018-12-06 17:30:00	SPY	ETF	269.88	269.91	269.75	269.8	80302.0
2018-12-06 18:00:00	SPY	ETF	269.76	270.0	269.51	269.85	185402.0
2018-12-06 18:30:00	SPY	ETF	269.84	269.91	269.42	269.87	64340.0
2018-12-06 19:00:00	SPY	ETF	269.9	270.14	269.44	269.47	68117.0
2018-12-06 19:30:00	SPY	ETF	269.55	269.55	269.28	269.48	94989.0
2018-12-06 04:00:00	QQQ	ETF	163.61	163.61	162.95	162.95	75914.0
2018-12-06 04:30:00	QQQ	ETF	162.99	162.99	161.91	161.92	53510.0
2018-12-06 05:00:00	QQQ	ETF	161.89	162.2	161.85	161.93	37240.0
2018-12-06 05:30:00	QQQ	ETF	161.84	162.34	161.78	162.04	116887.0
2018-12-06 06:00:00	QQQ	ETF	162.05	162.58	161.9	162.46	27978.0
2018-12-06 06:30:00	QQQ	ETF	162.55	162.59	162.0	162.35	46553.0
2018-12-06 07:00:00	QQQ	ETF	162.37	162.83	162.33	162.7	120636.0
2018-12-06 07:30:00	QQQ	ETF	162.74	162.99	162.41	162.76	209849.0
2018-12-06 08:00:00	QQQ	ETF	162.55	165.72	161.81	163.3	250587.0
2018-12-06 08:30:00	QQQ	ETF	163.28	163.28	162.74	162.78	281003.0
2018-12-06 09:00:00	QQQ	ETF	162.75	162.91	162.27	162.49	572185.0
2018-12-06 09:30:00	QQQ	ETF	162.48	164.16	162.03	162.67	9232798.0
2018-12-06 10:00:00	QQQ	ETF	162.69	163.97	162.45	163.74	5728005.0
2018-12-06 10:30:00	QQQ	ETF	163.76	163.91	162.66	162.78	4747370.0
2018-12-06 11:00:00	QQQ	ETF	162.77	163.07	161.77	162.01	4771398.0
2018-12-06 11:30:00	QQQ	ETF	161.99	164.09	161.925	164.06	4221722.0
2018-12-06 12:00:00	QQQ	ETF	164.07	165.2	163.56	165.12	4321404.0
2018-12-06 12:30:00	QQQ	ETF	165.14	165.81	164.78	165.41	4926311.0

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

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