PREVIEW / etf_30min / 2017-03-21

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-21.parquet
  size:    451 KB
  rows:    15,325

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
2017-03-21 04:00:00	SPY	ETF	237.09	237.35	237.09	237.25	1720.0
2017-03-21 04:30:00	SPY	ETF	237.29	237.29	237.29	237.29	501.0
2017-03-21 05:00:00	SPY	ETF	237.1	237.1	237.1	237.1	250.0
2017-03-21 05:30:00	SPY	ETF	237.1	237.1	237.1	237.1	100.0
2017-03-21 06:00:00	SPY	ETF	237.13	237.18	237.13	237.18	811.0
2017-03-21 06:30:00	SPY	ETF	237.23	237.28	237.13	237.13	12122.0
2017-03-21 07:00:00	SPY	ETF	237.2	237.3	237.14	237.24	19196.0
2017-03-21 07:30:00	SPY	ETF	237.3	237.41	237.21	237.24	86296.0
2017-03-21 08:00:00	SPY	ETF	237.16	237.39	237.12	237.15	149164.0
2017-03-21 08:30:00	SPY	ETF	237.14	237.23	237.11	237.23	89007.0
2017-03-21 09:00:00	SPY	ETF	237.24	237.48	237.24	237.47	299801.0
2017-03-21 09:30:00	SPY	ETF	237.47	237.61	237.13	237.14	4621574.0
2017-03-21 10:00:00	SPY	ETF	237.14	237.14	236.0	236.064	7074787.0
2017-03-21 10:30:00	SPY	ETF	236.0647	237.1308	235.18	235.41	10738909.0
2017-03-21 11:00:00	SPY	ETF	235.4	235.49	234.52	234.8699	11205439.0
2017-03-21 11:30:00	SPY	ETF	234.86	235.14	234.2401	235.135	12849736.0
2017-03-21 12:00:00	SPY	ETF	235.14	235.42	234.78	234.99	9633458.0
2017-03-21 12:30:00	SPY	ETF	234.98	235.09	234.38	234.66	6226078.0
2017-03-21 13:00:00	SPY	ETF	234.6611	234.8	234.14	234.55	5705503.0
2017-03-21 13:30:00	SPY	ETF	234.55	234.65	233.87	233.915	8102619.0
2017-03-21 14:00:00	SPY	ETF	233.915	235.3991	233.81	234.35	10335452.0
2017-03-21 14:30:00	SPY	ETF	234.35	234.72	234.04	234.44	6656527.0
2017-03-21 15:00:00	SPY	ETF	234.42	234.65	234.28	234.46	5596163.0
2017-03-21 15:30:00	SPY	ETF	234.46	234.4616	233.58	233.78	19857613.0
2017-03-21 16:00:00	SPY	ETF	233.77	234.08	233.66	233.85	7554715.0
2017-03-21 16:30:00	SPY	ETF	233.87	233.9	233.78	233.83	2565392.0
2017-03-21 17:00:00	SPY	ETF	233.83	233.83	233.69	233.7	343741.0
2017-03-21 17:30:00	SPY	ETF	233.7	233.77	233.69	233.73	92542.0
2017-03-21 18:00:00	SPY	ETF	233.75	233.86	233.58	233.62	426526.0
2017-03-21 18:30:00	SPY	ETF	233.61	233.69	233.4	233.58	92966.0
2017-03-21 19:00:00	SPY	ETF	233.59	233.73	233.5	233.7	43165.0
2017-03-21 19:30:00	SPY	ETF	233.67	233.67	233.5	233.53	27946.0
2017-03-21 04:00:00	QQQ	ETF	132.11	132.23	132.11	132.23	1800.0
2017-03-21 05:00:00	QQQ	ETF	132.11	132.11	132.11	132.11	999.0
2017-03-21 05:30:00	QQQ	ETF	132.15	132.16	132.15	132.16	500.0
2017-03-21 06:00:00	QQQ	ETF	132.11	132.15	132.11	132.14	25718.0
2017-03-21 06:30:00	QQQ	ETF	132.11	132.17	132.11	132.17	1899.0
2017-03-21 07:00:00	QQQ	ETF	132.12	132.17	132.12	132.16	23900.0
2017-03-21 07:30:00	QQQ	ETF	132.19	132.2	132.16	132.18	34000.0
2017-03-21 08:00:00	QQQ	ETF	132.2	132.2	132.14	132.14	48317.0
2017-03-21 08:30:00	QQQ	ETF	132.14	132.17	132.14	132.15	10219.0
2017-03-21 09:00:00	QQQ	ETF	132.19	132.32	132.19	132.3	62170.0
2017-03-21 09:30:00	QQQ	ETF	132.31	132.43	132.25	132.32	1626697.0
2017-03-21 10:00:00	QQQ	ETF	132.31	132.3107	131.56	131.6183	1897225.0
2017-03-21 10:30:00	QQQ	ETF	131.62	131.73	131.125	131.24	3118863.0
2017-03-21 11:00:00	QQQ	ETF	131.25	131.27	130.6	130.71	4172338.0
2017-03-21 11:30:00	QQQ	ETF	130.71	130.87	130.34	130.87	2912392.0
2017-03-21 12:00:00	QQQ	ETF	130.87	130.95	130.63	130.75	2408249.0
2017-03-21 12:30:00	QQQ	ETF	130.759	130.79	130.33	130.52	1386134.0
2017-03-21 13:00:00	QQQ	ETF	130.52	130.61	130.23	130.51	1483326.0

> showing 50 of 15,325 rows — these rows as CSV

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