PREVIEW / etf_1min / 2016-03-10

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-03-10.parquet
  size:    2.8 MB
  rows:    145,657

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
2016-03-10 04:00:00	SPY	ETF	199.93	200.13	199.93	200.0	1686.0
2016-03-10 04:01:00	SPY	ETF	200.02	200.02	200.02	200.02	210.0
2016-03-10 04:02:00	SPY	ETF	199.99	199.99	199.99	199.99	100.0
2016-03-10 04:05:00	SPY	ETF	200.07	200.12	200.07	200.12	504.0
2016-03-10 04:06:00	SPY	ETF	200.09	200.09	200.09	200.09	280.0
2016-03-10 04:09:00	SPY	ETF	199.97	199.97	199.97	199.97	370.0
2016-03-10 04:10:00	SPY	ETF	200.13	200.13	200.1	200.1	800.0
2016-03-10 04:11:00	SPY	ETF	200.12	200.12	200.12	200.12	250.0
2016-03-10 04:16:00	SPY	ETF	200.06	200.06	200.06	200.06	6681.0
2016-03-10 04:19:00	SPY	ETF	199.97	199.97	199.91	199.91	7010.0
2016-03-10 04:23:00	SPY	ETF	199.94	199.94	199.92	199.94	1823.0
2016-03-10 04:24:00	SPY	ETF	199.98	200.01	199.98	199.99	1331.0
2016-03-10 04:25:00	SPY	ETF	200.03	200.03	199.97	199.97	308.0
2016-03-10 04:26:00	SPY	ETF	199.9	199.9	199.9	199.9	103.0
2016-03-10 04:27:00	SPY	ETF	199.92	199.94	199.92	199.94	2105.0
2016-03-10 04:29:00	SPY	ETF	200.0	200.0	200.0	200.0	105.0
2016-03-10 04:30:00	SPY	ETF	199.96	199.96	199.96	199.96	104.0
2016-03-10 04:32:00	SPY	ETF	200.01	200.01	199.98	199.98	602.0
2016-03-10 04:34:00	SPY	ETF	199.96	199.96	199.96	199.96	105.0
2016-03-10 04:35:00	SPY	ETF	199.85	199.85	199.85	199.85	6146.0
2016-03-10 04:37:00	SPY	ETF	199.89	199.89	199.89	199.89	100.0
2016-03-10 04:38:00	SPY	ETF	199.84	199.84	199.82	199.82	1005.0
2016-03-10 04:39:00	SPY	ETF	199.75	199.75	199.69	199.69	1427.0
2016-03-10 04:41:00	SPY	ETF	199.7	199.7	199.69	199.69	3101.0
2016-03-10 04:42:00	SPY	ETF	199.69	199.69	199.69	199.69	532.0
2016-03-10 04:47:00	SPY	ETF	199.69	199.74	199.69	199.74	4406.0
2016-03-10 04:50:00	SPY	ETF	199.73	199.73	199.73	199.73	1044.0
2016-03-10 04:51:00	SPY	ETF	199.73	199.73	199.72	199.72	663.0
2016-03-10 05:00:00	SPY	ETF	199.6	199.63	199.59	199.63	2020.0
2016-03-10 05:01:00	SPY	ETF	199.68	199.68	199.68	199.68	168.0
2016-03-10 05:04:00	SPY	ETF	199.8	199.8	199.79	199.79	410.0
2016-03-10 05:05:00	SPY	ETF	199.78	199.79	199.77	199.79	605.0
2016-03-10 05:06:00	SPY	ETF	199.79	199.79	199.79	199.79	400.0
2016-03-10 05:08:00	SPY	ETF	199.79	199.79	199.7	199.75	955.0
2016-03-10 05:10:00	SPY	ETF	199.76	199.76	199.76	199.76	100.0
2016-03-10 05:12:00	SPY	ETF	199.8	199.8	199.79	199.79	402.0
2016-03-10 05:18:00	SPY	ETF	199.76	199.76	199.74	199.74	503.0
2016-03-10 05:24:00	SPY	ETF	199.73	199.73	199.73	199.73	633.0
2016-03-10 05:26:00	SPY	ETF	199.8	199.85	199.8	199.85	434.0
2016-03-10 05:29:00	SPY	ETF	199.76	199.76	199.76	199.76	121.0
2016-03-10 05:30:00	SPY	ETF	199.8	199.8	199.8	199.8	114.0
2016-03-10 05:33:00	SPY	ETF	199.76	199.76	199.76	199.76	102.0
2016-03-10 05:34:00	SPY	ETF	199.74	199.75	199.74	199.75	2302.0
2016-03-10 05:37:00	SPY	ETF	199.77	199.77	199.77	199.77	104.0
2016-03-10 05:38:00	SPY	ETF	199.79	199.79	199.76	199.76	224.0
2016-03-10 05:39:00	SPY	ETF	199.76	199.78	199.76	199.78	302.0
2016-03-10 05:42:00	SPY	ETF	199.79	199.8	199.79	199.8	202.0
2016-03-10 05:43:00	SPY	ETF	199.82	199.82	199.82	199.82	113.0
2016-03-10 05:44:00	SPY	ETF	199.86	199.94	199.86	199.94	2315.0
2016-03-10 05:46:00	SPY	ETF	199.89	199.92	199.88	199.88	512.0

> showing 50 of 145,657 rows — these rows as CSV

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