PREVIEW / etf_5min / 2010-05-17

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-05-17.parquet
  size:    893 KB
  rows:    36,317

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
2010-05-17 04:15:00	SPY	ETF	113.63	113.72	113.55	113.72	700.0
2010-05-17 04:20:00	SPY	ETF	113.54	113.54	113.53	113.53	200.0
2010-05-17 04:30:00	SPY	ETF	113.76	113.76	113.76	113.76	100.0
2010-05-17 04:35:00	SPY	ETF	113.78	113.78	113.68	113.68	500.0
2010-05-17 04:40:00	SPY	ETF	113.83	113.84	113.83	113.84	200.0
2010-05-17 04:50:00	SPY	ETF	113.76	113.76	113.76	113.76	100.0
2010-05-17 05:15:00	SPY	ETF	114.01	114.27	114.01	114.27	400.0
2010-05-17 05:20:00	SPY	ETF	114.14	114.16	114.13	114.14	10000.0
2010-05-17 05:25:00	SPY	ETF	114.17	114.17	114.17	114.17	600.0
2010-05-17 05:35:00	SPY	ETF	114.09	114.09	114.09	114.09	100.0
2010-05-17 05:40:00	SPY	ETF	114.07	114.07	114.06	114.06	300.0
2010-05-17 05:50:00	SPY	ETF	114.03	114.03	114.03	114.03	6586.0
2010-05-17 06:00:00	SPY	ETF	113.99	113.99	113.99	113.99	4930.0
2010-05-17 06:05:00	SPY	ETF	114.11	114.11	114.11	114.11	100.0
2010-05-17 06:10:00	SPY	ETF	114.08	114.08	114.08	114.08	5000.0
2010-05-17 06:15:00	SPY	ETF	114.11	114.11	114.11	114.11	500.0
2010-05-17 06:20:00	SPY	ETF	114.16	114.16	114.16	114.16	500.0
2010-05-17 06:30:00	SPY	ETF	114.16	114.16	114.16	114.16	500.0
2010-05-17 06:35:00	SPY	ETF	114.18	114.21	114.18	114.21	2600.0
2010-05-17 06:40:00	SPY	ETF	114.3	114.38	114.25	114.25	87400.0
2010-05-17 06:45:00	SPY	ETF	114.31	114.31	114.24	114.25	16800.0
2010-05-17 06:50:00	SPY	ETF	114.23	114.23	114.2	114.22	46700.0
2010-05-17 06:55:00	SPY	ETF	114.23	114.23	114.14	114.14	2400.0
2010-05-17 07:00:00	SPY	ETF	114.11	114.22	114.09	114.2	80800.0
2010-05-17 07:05:00	SPY	ETF	114.18	114.22	114.18	114.21	46555.0
2010-05-17 07:10:00	SPY	ETF	114.21	114.22	114.21	114.22	1100.0
2010-05-17 07:15:00	SPY	ETF	114.16	114.3	114.16	114.27	131290.0
2010-05-17 07:20:00	SPY	ETF	114.25	114.46	114.24	114.43	31990.0
2010-05-17 07:25:00	SPY	ETF	114.38	114.46	114.38	114.46	38306.0
2010-05-17 07:30:00	SPY	ETF	114.45	114.46	114.32	114.32	24412.0
2010-05-17 07:35:00	SPY	ETF	114.35	114.35	114.23	114.29	35284.0
2010-05-17 07:40:00	SPY	ETF	114.29	114.32	114.27	114.29	36800.0
2010-05-17 07:45:00	SPY	ETF	114.32	114.4	114.31	114.4	33500.0
2010-05-17 07:50:00	SPY	ETF	114.39	114.41	114.31	114.34	18600.0
2010-05-17 07:55:00	SPY	ETF	114.32	114.34	114.27	114.3	68200.0
2010-05-17 08:00:00	SPY	ETF	114.28	114.33	113.3	114.2112	749702.0
2010-05-17 08:05:00	SPY	ETF	114.26	114.33	114.22	114.25	158023.0
2010-05-17 08:10:00	SPY	ETF	114.23	114.23	113.96	114.01	828552.0
2010-05-17 08:15:00	SPY	ETF	113.4	114.01	112.6	113.93	606979.0
2010-05-17 08:20:00	SPY	ETF	113.91	113.92	113.61	113.64	710148.0
2010-05-17 08:25:00	SPY	ETF	113.65	113.74	113.6	113.62	253987.0
2010-05-17 08:30:00	SPY	ETF	113.6	113.9105	113.47	113.75	514059.0
2010-05-17 08:35:00	SPY	ETF	113.75	114.26	113.61	113.85	286473.0
2010-05-17 08:40:00	SPY	ETF	113.84	113.91	113.72	113.9	163589.0
2010-05-17 08:45:00	SPY	ETF	113.9	113.91	113.72	113.8	350731.0
2010-05-17 08:50:00	SPY	ETF	113.77	113.98	113.75	113.92	362508.0
2010-05-17 08:55:00	SPY	ETF	113.9	113.95	113.83	113.9	253295.0
2010-05-17 09:00:00	SPY	ETF	113.9	114.01	113.84	113.99	178552.0
2010-05-17 09:05:00	SPY	ETF	114.0	114.04	113.89	114.01	273051.0
2010-05-17 09:10:00	SPY	ETF	114.02	114.04	113.88	113.93	447235.0

> showing 50 of 36,317 rows — these rows as CSV

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