PREVIEW / etf_30min / 2015-10-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-23.parquet
  size:    394 KB
  rows:    13,276

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
2015-10-23 04:00:00	SPY	ETF	206.21	206.21	206.12	206.19	9871.0
2015-10-23 04:30:00	SPY	ETF	206.1	206.15	206.1	206.15	1036.0
2015-10-23 05:00:00	SPY	ETF	206.17	206.29	206.14	206.29	9008.0
2015-10-23 05:30:00	SPY	ETF	206.45	206.71	206.45	206.71	18452.0
2015-10-23 06:00:00	SPY	ETF	206.73	206.94	206.68	206.79	24151.0
2015-10-23 06:30:00	SPY	ETF	206.78	206.79	206.69	206.72	19300.0
2015-10-23 07:00:00	SPY	ETF	206.72	208.02	206.68	208.0	875240.0
2015-10-23 07:30:00	SPY	ETF	207.96	207.96	207.36	207.63	767623.0
2015-10-23 08:00:00	SPY	ETF	207.63	207.97	206.33	207.46	850142.0
2015-10-23 08:30:00	SPY	ETF	207.45	207.63	207.41	207.6	834892.0
2015-10-23 09:00:00	SPY	ETF	207.61	207.63	207.16	207.27	1014817.0
2015-10-23 09:30:00	SPY	ETF	207.25	207.76	206.86	207.68	19979535.0
2015-10-23 10:00:00	SPY	ETF	207.69	207.76	206.94	206.98	12240563.0
2015-10-23 10:30:00	SPY	ETF	206.99	207.45	206.74	206.98	9778635.0
2015-10-23 11:00:00	SPY	ETF	206.99	207.28	206.53	206.7	8929991.0
2015-10-23 11:30:00	SPY	ETF	206.695	206.78	206.3	206.4975	8526309.0
2015-10-23 12:00:00	SPY	ETF	206.51	206.97	206.36	206.95	5674362.0
2015-10-23 12:30:00	SPY	ETF	206.95	207.04	206.73	207.0	4751643.0
2015-10-23 13:00:00	SPY	ETF	206.99	207.25	206.68	207.16	4632784.0
2015-10-23 13:30:00	SPY	ETF	207.16	207.48	207.16	207.32	8024521.0
2015-10-23 14:00:00	SPY	ETF	207.321	207.65	207.17	207.51	8062153.0
2015-10-23 14:30:00	SPY	ETF	207.51	207.95	207.49	207.69	8706911.0
2015-10-23 15:00:00	SPY	ETF	207.69	207.87	207.21	207.32	9754357.0
2015-10-23 15:30:00	SPY	ETF	207.32	207.65	207.3	207.51	16143879.0
2015-10-23 16:00:00	SPY	ETF	207.49	207.5986	207.15	207.21	9017225.0
2015-10-23 16:30:00	SPY	ETF	207.19	207.51	207.1	207.51	2982562.0
2015-10-23 17:00:00	SPY	ETF	207.13	207.25	207.09	207.25	106360.0
2015-10-23 17:30:00	SPY	ETF	207.25	207.35	207.22	207.27	42105.0
2015-10-23 18:00:00	SPY	ETF	207.31	207.32	207.28	207.28	7064.0
2015-10-23 18:30:00	SPY	ETF	207.3	207.3	207.25	207.29	15733.0
2015-10-23 19:00:00	SPY	ETF	207.29	207.3	207.26	207.29	3423.0
2015-10-23 19:30:00	SPY	ETF	207.3	207.3	207.27	207.29	11304.0
2015-10-23 04:00:00	QQQ	ETF	111.49	111.64	111.49	111.64	21358.0
2015-10-23 04:30:00	QQQ	ETF	111.64	111.69	111.64	111.69	10100.0
2015-10-23 05:00:00	QQQ	ETF	111.71	111.71	111.71	111.71	5720.0
2015-10-23 05:30:00	QQQ	ETF	111.85	111.9	111.85	111.9	15500.0
2015-10-23 06:00:00	QQQ	ETF	111.95	112.09	111.94	112.05	20145.0
2015-10-23 06:30:00	QQQ	ETF	112.05	112.06	111.94	111.95	34256.0
2015-10-23 07:00:00	QQQ	ETF	111.99	112.98	111.95	112.97	425900.0
2015-10-23 07:30:00	QQQ	ETF	112.96	112.96	112.67	112.92	218395.0
2015-10-23 08:00:00	QQQ	ETF	112.92	112.94	111.98	112.66	226562.0
2015-10-23 08:30:00	QQQ	ETF	112.68	112.75	112.62	112.67	200946.0
2015-10-23 09:00:00	QQQ	ETF	112.7	112.7	112.58	112.68	383394.0
2015-10-23 09:30:00	QQQ	ETF	112.66	112.84	112.1049	112.76	10324290.0
2015-10-23 10:00:00	QQQ	ETF	112.756	112.8	112.12	112.15	4884101.0
2015-10-23 10:30:00	QQQ	ETF	112.15	112.46	112.08	112.28	3301755.0
2015-10-23 11:00:00	QQQ	ETF	112.27	112.45	112.18	112.3773	2694456.0
2015-10-23 11:30:00	QQQ	ETF	112.38	112.3999	112.12	112.17	1764912.0
2015-10-23 12:00:00	QQQ	ETF	112.17	112.58	112.07	112.56	1942975.0
2015-10-23 12:30:00	QQQ	ETF	112.57	112.62	112.37	112.56	1583751.0

> showing 50 of 13,276 rows — these rows as CSV

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