PREVIEW / etf_30min / 2017-07-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-24.parquet
  size:    422 KB
  rows:    14,667

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-07-24 04:00:00	SPY	ETF	246.51	246.51	246.25	246.44	3620.0
2017-07-24 04:30:00	SPY	ETF	246.41	246.41	246.35	246.37	17000.0
2017-07-24 05:00:00	SPY	ETF	246.41	246.41	246.26	246.26	2163.0
2017-07-24 05:30:00	SPY	ETF	246.3	246.39	246.3	246.37	2400.0
2017-07-24 06:00:00	SPY	ETF	246.39	246.52	246.39	246.52	1125.0
2017-07-24 06:30:00	SPY	ETF	246.56	246.56	246.54	246.56	580.0
2017-07-24 07:00:00	SPY	ETF	246.6	246.61	246.54	246.6	58429.0
2017-07-24 07:30:00	SPY	ETF	246.63	246.65	246.58	246.6	23922.0
2017-07-24 08:00:00	SPY	ETF	246.57	246.88	246.56	246.84	895178.0
2017-07-24 08:30:00	SPY	ETF	246.86	246.86	246.76	246.76	1185663.0
2017-07-24 09:00:00	SPY	ETF	246.75	246.84	246.69	246.81	199216.0
2017-07-24 09:30:00	SPY	ETF	246.79	246.85	246.42	246.6	3384033.0
2017-07-24 10:00:00	SPY	ETF	246.605	246.7788	246.43	246.4556	2602293.0
2017-07-24 10:30:00	SPY	ETF	246.46	246.54	246.37	246.44	2083815.0
2017-07-24 11:00:00	SPY	ETF	246.44	246.5	246.28	246.42	2405960.0
2017-07-24 11:30:00	SPY	ETF	246.419	246.59	246.4	246.567	1392924.0
2017-07-24 12:00:00	SPY	ETF	246.57	246.71	246.56	246.6699	1189344.0
2017-07-24 12:30:00	SPY	ETF	246.665	246.68	246.59	246.67	1097855.0
2017-07-24 13:00:00	SPY	ETF	246.66	246.71	246.59	246.66	1633263.0
2017-07-24 13:30:00	SPY	ETF	246.66	246.68	246.6	246.625	1287825.0
2017-07-24 14:00:00	SPY	ETF	246.63	246.81	246.62	246.76	1376355.0
2017-07-24 14:30:00	SPY	ETF	246.75	246.84	246.73	246.79	1697413.0
2017-07-24 15:00:00	SPY	ETF	246.7942	246.96	246.74	246.94	2213064.0
2017-07-24 15:30:00	SPY	ETF	246.94	246.98	246.69	246.81	8900773.0
2017-07-24 16:00:00	SPY	ETF	246.8	246.82	246.61	246.67	11671908.0
2017-07-24 16:30:00	SPY	ETF	246.69	246.69	246.55	246.64	358374.0
2017-07-24 17:00:00	SPY	ETF	246.6	246.63	246.57	246.59	52717.0
2017-07-24 17:30:00	SPY	ETF	246.6	246.67	246.6	246.65	77104.0
2017-07-24 18:00:00	SPY	ETF	246.62	246.7	246.58	246.62	71449.0
2017-07-24 18:30:00	SPY	ETF	246.65	246.67	246.62	246.66	3837.0
2017-07-24 19:00:00	SPY	ETF	246.66	246.66	246.65	246.65	5649.0
2017-07-24 19:30:00	SPY	ETF	246.66	246.68	246.66	246.68	8000.0
2017-07-24 20:00:00	SPY	ETF	246.82	246.82	246.6423	246.6463	213000.0
2017-07-24 04:00:00	QQQ	ETF	143.89	143.89	143.81	143.86	876.0
2017-07-24 04:30:00	QQQ	ETF	143.84	143.92	143.84	143.92	1190.0
2017-07-24 05:00:00	QQQ	ETF	143.81	143.81	143.77	143.77	1504.0
2017-07-24 05:30:00	QQQ	ETF	143.87	143.87	143.87	143.87	2000.0
2017-07-24 06:00:00	QQQ	ETF	143.9	144.0	143.9	143.91	15800.0
2017-07-24 06:30:00	QQQ	ETF	143.94	143.95	143.9	143.91	15436.0
2017-07-24 07:00:00	QQQ	ETF	143.9	143.93	143.9	143.91	23310.0
2017-07-24 07:30:00	QQQ	ETF	143.91	143.93	143.88	143.89	24008.0
2017-07-24 08:00:00	QQQ	ETF	143.93	144.17	143.86	144.13	148034.0
2017-07-24 08:30:00	QQQ	ETF	144.13	144.14	144.03	144.05	130612.0
2017-07-24 09:00:00	QQQ	ETF	144.07	144.1	144.01	144.07	26992.0
2017-07-24 09:30:00	QQQ	ETF	144.07	144.26	143.98	144.21	1820938.0
2017-07-24 10:00:00	QQQ	ETF	144.2	144.26	144.06	144.1299	1373995.0
2017-07-24 10:30:00	QQQ	ETF	144.12	144.19	144.05	144.1747	798360.0
2017-07-24 11:00:00	QQQ	ETF	144.17	144.1746	143.92	143.9825	1211955.0
2017-07-24 11:30:00	QQQ	ETF	143.99	144.17	143.98	144.15	600478.0
2017-07-24 12:00:00	QQQ	ETF	144.16	144.34	144.15	144.32	886319.0

> showing 50 of 14,667 rows — these rows as CSV

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