PREVIEW / etf_30min / 2017-09-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-09-05.parquet
  size:    457 KB
  rows:    15,689

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-09-05 04:00:00	SPY	ETF	247.3	247.3	247.3	247.3	413.0
2017-09-05 04:30:00	SPY	ETF	247.42	247.42	247.29	247.29	780.0
2017-09-05 05:00:00	SPY	ETF	247.31	247.37	247.3	247.37	1904.0
2017-09-05 05:30:00	SPY	ETF	247.3	247.3	247.16	247.17	17613.0
2017-09-05 06:00:00	SPY	ETF	247.16	247.16	246.94	246.94	9702.0
2017-09-05 06:30:00	SPY	ETF	246.95	247.05	246.94	247.03	79871.0
2017-09-05 07:00:00	SPY	ETF	247.05	247.28	247.03	247.25	35564.0
2017-09-05 07:30:00	SPY	ETF	247.25	247.32	247.23	247.3	92342.0
2017-09-05 08:00:00	SPY	ETF	247.31	247.4	247.06	247.24	472460.0
2017-09-05 08:30:00	SPY	ETF	247.23	247.84	247.19	247.22	297843.0
2017-09-05 09:00:00	SPY	ETF	247.22	247.34	247.21	247.25	391156.0
2017-09-05 09:30:00	SPY	ETF	247.26	247.52	246.93	247.3699	6690675.0
2017-09-05 10:00:00	SPY	ETF	247.37	247.48	247.06	247.12	4282022.0
2017-09-05 10:30:00	SPY	ETF	247.12	247.15	246.61	246.83	4614269.0
2017-09-05 11:00:00	SPY	ETF	246.83	246.885	246.46	246.62	4030042.0
2017-09-05 11:30:00	SPY	ETF	246.61	246.85	246.5625	246.77	1969125.0
2017-09-05 12:00:00	SPY	ETF	246.75	246.75	245.71	245.735	8245304.0
2017-09-05 12:30:00	SPY	ETF	245.73	245.74	245.28	245.55	7465539.0
2017-09-05 13:00:00	SPY	ETF	245.555	245.59	244.95	245.41	8949989.0
2017-09-05 13:30:00	SPY	ETF	245.41	245.77	245.18	245.745	4443884.0
2017-09-05 14:00:00	SPY	ETF	245.74	246.15	245.61	246.06	5129507.0
2017-09-05 14:30:00	SPY	ETF	246.06	246.13	245.71	245.82	4337145.0
2017-09-05 15:00:00	SPY	ETF	245.83	246.11	245.57	246.09	4862435.0
2017-09-05 15:30:00	SPY	ETF	246.09	246.25	245.79	246.1	13269586.0
2017-09-05 16:00:00	SPY	ETF	246.1	246.48	246.06	246.42	7623855.0
2017-09-05 16:30:00	SPY	ETF	246.43	247.1015	246.1001	246.39	614064.0
2017-09-05 17:00:00	SPY	ETF	246.39	246.44	246.33	246.35	99045.0
2017-09-05 17:30:00	SPY	ETF	246.35	246.42	246.126	246.38	1043119.0
2017-09-05 18:00:00	SPY	ETF	246.38	246.38	246.19	246.19	122412.0
2017-09-05 18:30:00	SPY	ETF	246.24	246.24	246.13	246.18	25117.0
2017-09-05 19:00:00	SPY	ETF	246.22	246.27	246.19	246.22	15005.0
2017-09-05 19:30:00	SPY	ETF	246.23	246.26	246.15	246.22	20998.0
2017-09-05 04:00:00	QQQ	ETF	145.75	145.75	145.75	145.75	500.0
2017-09-05 04:30:00	QQQ	ETF	145.82	145.83	145.82	145.83	10300.0
2017-09-05 05:30:00	QQQ	ETF	145.73	145.73	145.73	145.73	4600.0
2017-09-05 06:00:00	QQQ	ETF	145.71	145.77	145.64	145.64	1200.0
2017-09-05 06:30:00	QQQ	ETF	145.61	145.61	145.57	145.58	399.0
2017-09-05 07:00:00	QQQ	ETF	145.68	145.79	145.68	145.73	22687.0
2017-09-05 07:30:00	QQQ	ETF	145.78	145.78	145.73	145.77	13177.0
2017-09-05 08:00:00	QQQ	ETF	145.76	145.79	145.62	145.65	50338.0
2017-09-05 08:30:00	QQQ	ETF	145.64	145.79	145.63	145.64	40883.0
2017-09-05 09:00:00	QQQ	ETF	145.64	145.68	145.51	145.52	78968.0
2017-09-05 09:30:00	QQQ	ETF	145.53	145.82	145.08	145.73	3672530.0
2017-09-05 10:00:00	QQQ	ETF	145.74	145.88	145.4607	145.51	2268595.0
2017-09-05 10:30:00	QQQ	ETF	145.505	145.53	145.16	145.35	2017145.0
2017-09-05 11:00:00	QQQ	ETF	145.36	145.36	144.89	145.0	1441777.0
2017-09-05 11:30:00	QQQ	ETF	145.0064	145.2	144.941	145.08	1117815.0
2017-09-05 12:00:00	QQQ	ETF	145.08	145.08	144.13	144.154	3057129.0
2017-09-05 12:30:00	QQQ	ETF	144.16	144.18	143.75	144.07	2969544.0
2017-09-05 13:00:00	QQQ	ETF	144.0634	144.08	143.6	143.97	3497666.0

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

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