PREVIEW / etf_30min / 2018-12-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-07.parquet
  size:    508 KB
  rows:    17,571

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-07 04:00:00	SPY	ETF	268.34	268.35	267.93	268.35	5472.0
2018-12-07 04:30:00	SPY	ETF	268.3	268.74	268.2	268.74	15666.0
2018-12-07 05:00:00	SPY	ETF	268.63	268.63	268.32	268.36	2270.0
2018-12-07 05:30:00	SPY	ETF	268.45	268.77	268.41	268.41	2900.0
2018-12-07 06:00:00	SPY	ETF	268.29	268.44	268.08	268.1	37940.0
2018-12-07 06:30:00	SPY	ETF	268.15	268.2	267.85	267.85	66395.0
2018-12-07 07:00:00	SPY	ETF	267.87	268.18	267.72	267.9	118231.0
2018-12-07 07:30:00	SPY	ETF	267.85	268.15	267.77	268.1	416217.0
2018-12-07 08:00:00	SPY	ETF	267.9401	269.15	267.45	268.84	434033.0
2018-12-07 08:30:00	SPY	ETF	268.84	270.1	267.75	269.29	1208746.0
2018-12-07 09:00:00	SPY	ETF	269.32	269.65	269.32	269.46	499547.0
2018-12-07 09:30:00	SPY	ETF	269.46	271.22	269.25	270.36	10500896.0
2018-12-07 10:00:00	SPY	ETF	270.37	270.71	267.58	268.2633	11733036.0
2018-12-07 10:30:00	SPY	ETF	268.27	268.45	267.02	268.24	9335724.0
2018-12-07 11:00:00	SPY	ETF	268.245	268.51	265.53	266.0325	10964039.0
2018-12-07 11:30:00	SPY	ETF	266.01	267.005	265.35	265.36	8301197.0
2018-12-07 12:00:00	SPY	ETF	265.37	266.42	265.27	265.79	6957612.0
2018-12-07 12:30:00	SPY	ETF	265.785	266.55	264.56	266.27	8114732.0
2018-12-07 13:00:00	SPY	ETF	266.26	266.91	265.12	265.77	6556915.0
2018-12-07 13:30:00	SPY	ETF	265.77	265.83	264.37	264.4	7003548.0
2018-12-07 14:00:00	SPY	ETF	264.4	265.0762	263.46	264.67	11008003.0
2018-12-07 14:30:00	SPY	ETF	264.68	264.86	262.96	263.16	8383654.0
2018-12-07 15:00:00	SPY	ETF	263.16	264.26	262.63	263.96	13057399.0
2018-12-07 15:30:00	SPY	ETF	263.9675	265.46	263.43	263.65	27263724.0
2018-12-07 16:00:00	SPY	ETF	263.63	264.05	263.45	263.6	15157069.0
2018-12-07 16:30:00	SPY	ETF	263.6	264.05	263.57	264.04	1593928.0
2018-12-07 17:00:00	SPY	ETF	263.77	263.94	263.57	263.89	68426.0
2018-12-07 17:30:00	SPY	ETF	263.9	263.91	263.57	263.81	30689.0
2018-12-07 18:00:00	SPY	ETF	263.77	263.79	263.61	263.64	16475.0
2018-12-07 18:30:00	SPY	ETF	263.64	263.67	263.07	263.5	75237.0
2018-12-07 19:00:00	SPY	ETF	263.5	263.5499	263.34	263.38	10931.0
2018-12-07 19:30:00	SPY	ETF	263.38	263.39	263.31	263.31	14990.0
2018-12-07 04:00:00	QQQ	ETF	166.52	166.59	165.47	165.77	69995.0
2018-12-07 04:30:00	QQQ	ETF	165.68	166.05	165.68	166.05	14940.0
2018-12-07 05:00:00	QQQ	ETF	165.91	165.98	165.62	165.64	20490.0
2018-12-07 05:30:00	QQQ	ETF	165.71	166.02	165.71	165.77	7190.0
2018-12-07 06:00:00	QQQ	ETF	165.75	165.8	165.51	165.54	18116.0
2018-12-07 06:30:00	QQQ	ETF	165.57	165.61	165.29	165.29	26490.0
2018-12-07 07:00:00	QQQ	ETF	165.32	165.58	165.26	165.39	90757.0
2018-12-07 07:30:00	QQQ	ETF	165.39	165.73	165.34	165.7	137662.0
2018-12-07 08:00:00	QQQ	ETF	165.7	166.51	165.3	165.93	203775.0
2018-12-07 08:30:00	QQQ	ETF	166.21	166.96	166.05	166.16	675036.0
2018-12-07 09:00:00	QQQ	ETF	166.13	166.39	166.03	166.12	311527.0
2018-12-07 09:30:00	QQQ	ETF	166.13	167.12	165.89	166.44	5768693.0
2018-12-07 10:00:00	QQQ	ETF	166.45	166.81	164.56	165.07	5384806.0
2018-12-07 10:30:00	QQQ	ETF	165.08	165.2085	164.12	164.74	4026396.0
2018-12-07 11:00:00	QQQ	ETF	164.73	164.89	163.1	163.49	4743505.0
2018-12-07 11:30:00	QQQ	ETF	163.49	164.1115	162.83	162.85	4495319.0
2018-12-07 12:00:00	QQQ	ETF	162.84	163.63	162.78	163.26	3228855.0
2018-12-07 12:30:00	QQQ	ETF	163.24	163.56	162.27	163.355	3444776.0

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

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