PREVIEW / etf_30min / 2018-02-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-14.parquet
  size:    493 KB
  rows:    16,887

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-02-14 04:00:00	SPY	ETF	267.3	267.45	267.24	267.43	18495.0
2018-02-14 04:30:00	SPY	ETF	267.38	267.46	267.02	267.02	18863.0
2018-02-14 05:00:00	SPY	ETF	267.02	267.27	266.85	267.22	7100.0
2018-02-14 05:30:00	SPY	ETF	267.17	267.17	266.97	267.07	6441.0
2018-02-14 06:00:00	SPY	ETF	267.05	267.22	267.0	267.15	15644.0
2018-02-14 06:30:00	SPY	ETF	267.17	267.32	267.09	267.19	4200.0
2018-02-14 07:00:00	SPY	ETF	267.17	267.26	267.07	267.18	89242.0
2018-02-14 07:30:00	SPY	ETF	267.17	267.23	266.97	267.0	63603.0
2018-02-14 08:00:00	SPY	ETF	267.17	267.44	266.4	267.34	966819.0
2018-02-14 08:30:00	SPY	ETF	267.4	267.4	262.62	264.1	6626447.0
2018-02-14 09:00:00	SPY	ETF	264.1	264.82	263.55	264.47	2313986.0
2018-02-14 09:30:00	SPY	ETF	264.31	266.0763	264.3	265.08	14325312.0
2018-02-14 10:00:00	SPY	ETF	265.09	267.32	264.89	266.83	12730531.0
2018-02-14 10:30:00	SPY	ETF	266.83	267.58	266.41	267.0	6516023.0
2018-02-14 11:00:00	SPY	ETF	267.01	267.57	266.5866	267.375	4889609.0
2018-02-14 11:30:00	SPY	ETF	267.39	267.83	266.82	266.93	6789492.0
2018-02-14 12:00:00	SPY	ETF	266.96	267.65	266.71	267.52	3546438.0
2018-02-14 12:30:00	SPY	ETF	267.51	268.27	267.36	268.12	3271362.0
2018-02-14 13:00:00	SPY	ETF	268.12	269.18	268.05	268.64	6067391.0
2018-02-14 13:30:00	SPY	ETF	268.64	269.3	268.64	269.02	5766985.0
2018-02-14 14:00:00	SPY	ETF	269.0189	269.46	268.53	268.55	5746926.0
2018-02-14 14:30:00	SPY	ETF	268.5575	269.329	268.445	269.22	5332576.0
2018-02-14 15:00:00	SPY	ETF	269.22	269.98	269.22	269.5	6900528.0
2018-02-14 15:30:00	SPY	ETF	269.5	270.0	269.28	269.71	19212328.0
2018-02-14 16:00:00	SPY	ETF	269.7	269.75	267.95	269.46	6122483.0
2018-02-14 16:30:00	SPY	ETF	269.45	269.73	268.336	269.47	677416.0
2018-02-14 17:00:00	SPY	ETF	269.48	269.54	269.41	269.44	141889.0
2018-02-14 17:30:00	SPY	ETF	269.44	269.6376	269.0	269.38	184902.0
2018-02-14 18:00:00	SPY	ETF	269.37	269.5	269.29	269.49	88301.0
2018-02-14 18:30:00	SPY	ETF	269.46	269.52	269.32	269.35	41088.0
2018-02-14 19:00:00	SPY	ETF	269.37	269.48	269.24	269.3	25317.0
2018-02-14 19:30:00	SPY	ETF	269.28	269.66	269.26	269.61	70182.0
2018-02-14 20:00:00	SPY	ETF	269.62	269.62	269.62	269.62	1186.0
2018-02-14 04:00:00	QQQ	ETF	160.67	160.77	160.58	160.68	29075.0
2018-02-14 04:30:00	QQQ	ETF	160.66	160.66	160.47	160.47	13800.0
2018-02-14 05:00:00	QQQ	ETF	160.56	160.56	160.3	160.56	15692.0
2018-02-14 05:30:00	QQQ	ETF	160.53	160.53	160.35	160.47	3700.0
2018-02-14 06:00:00	QQQ	ETF	160.43	160.57	160.43	160.52	8800.0
2018-02-14 06:30:00	QQQ	ETF	160.52	160.6	160.48	160.48	27891.0
2018-02-14 07:00:00	QQQ	ETF	160.5	160.7	160.41	160.6	102010.0
2018-02-14 07:30:00	QQQ	ETF	160.62	160.63	160.43	160.43	75030.0
2018-02-14 08:00:00	QQQ	ETF	160.43	160.68	159.93	160.57	78558.0
2018-02-14 08:30:00	QQQ	ETF	160.51	160.51	155.88	158.65	1764385.0
2018-02-14 09:00:00	QQQ	ETF	158.6	158.9	158.19	158.83	354255.0
2018-02-14 09:30:00	QQQ	ETF	158.8	160.15	158.0	159.47	6686711.0
2018-02-14 10:00:00	QQQ	ETF	159.49	161.16	159.3862	160.94	6045974.0
2018-02-14 10:30:00	QQQ	ETF	160.95	161.375	160.515	160.99	2997130.0
2018-02-14 11:00:00	QQQ	ETF	160.97	161.36	160.77	161.23	1942069.0
2018-02-14 11:30:00	QQQ	ETF	161.23	161.7	160.92	160.9633	2718955.0
2018-02-14 12:00:00	QQQ	ETF	160.97	161.27	160.68	161.2	2472135.0

> showing 50 of 16,887 rows — these rows as CSV

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