PREVIEW / etf_5min / 2013-01-28

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-28.parquet
  size:    970 KB
  rows:    41,745

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
2013-01-28 04:00:00	SPY	ETF	150.03	150.03	150.03	150.03	357.0
2013-01-28 04:40:00	SPY	ETF	149.99	149.99	149.99	149.99	500.0
2013-01-28 04:45:00	SPY	ETF	150.0	150.0	150.0	150.0	5000.0
2013-01-28 05:05:00	SPY	ETF	150.03	150.03	150.03	150.03	500.0
2013-01-28 05:35:00	SPY	ETF	150.04	150.08	150.04	150.08	1000.0
2013-01-28 05:45:00	SPY	ETF	150.03	150.05	150.03	150.05	1850.0
2013-01-28 05:50:00	SPY	ETF	150.04	150.05	150.04	150.05	2000.0
2013-01-28 05:55:00	SPY	ETF	150.05	150.05	150.05	150.05	1000.0
2013-01-28 06:05:00	SPY	ETF	149.97	149.97	149.97	149.97	136.0
2013-01-28 06:35:00	SPY	ETF	149.99	150.02	149.99	150.02	10294.0
2013-01-28 06:45:00	SPY	ETF	150.0	150.0	149.99	149.99	12000.0
2013-01-28 07:00:00	SPY	ETF	150.04	150.05	150.02	150.02	19100.0
2013-01-28 07:05:00	SPY	ETF	150.02	150.05	149.99	150.05	10000.0
2013-01-28 07:10:00	SPY	ETF	150.02	150.05	150.02	150.05	24265.0
2013-01-28 07:15:00	SPY	ETF	150.06	150.06	150.06	150.06	1200.0
2013-01-28 07:20:00	SPY	ETF	150.06	150.14	150.06	150.14	7900.0
2013-01-28 07:25:00	SPY	ETF	150.15	150.15	150.09	150.09	16592.0
2013-01-28 07:30:00	SPY	ETF	150.09	150.1	150.05	150.1	9350.0
2013-01-28 07:35:00	SPY	ETF	150.1	150.1	150.05	150.05	2600.0
2013-01-28 07:40:00	SPY	ETF	150.1	150.15	150.1	150.12	26205.0
2013-01-28 07:45:00	SPY	ETF	150.12	150.13	150.09	150.12	6900.0
2013-01-28 07:50:00	SPY	ETF	150.14	150.18	150.12	150.18	8220.0
2013-01-28 07:55:00	SPY	ETF	150.18	150.2	150.14	150.17	18600.0
2013-01-28 08:00:00	SPY	ETF	150.19	150.2	150.04	150.16	50791.0
2013-01-28 08:05:00	SPY	ETF	150.16	150.16	150.13	150.13	7140.0
2013-01-28 08:10:00	SPY	ETF	150.13	150.14	150.08	150.08	36459.0
2013-01-28 08:15:00	SPY	ETF	150.1	150.14	150.1	150.12	19650.0
2013-01-28 08:20:00	SPY	ETF	150.13	150.13	150.06	150.07	8915.0
2013-01-28 08:25:00	SPY	ETF	150.06	150.07	150.0	150.04	46421.0
2013-01-28 08:30:00	SPY	ETF	150.02	150.25	150.02	150.23	316217.0
2013-01-28 08:35:00	SPY	ETF	150.22	150.23	150.1	150.12	159097.0
2013-01-28 08:40:00	SPY	ETF	150.15	150.21	150.13	150.2	45700.0
2013-01-28 08:45:00	SPY	ETF	150.19	150.29	149.965	150.28	99869.0
2013-01-28 08:50:00	SPY	ETF	150.27	150.36	149.965	150.34	215770.0
2013-01-28 08:55:00	SPY	ETF	150.34	150.36	150.31	150.31	92087.0
2013-01-28 09:00:00	SPY	ETF	150.33	150.34	150.26	150.26	44304.0
2013-01-28 09:05:00	SPY	ETF	150.27	150.28	150.23	150.27	74400.0
2013-01-28 09:10:00	SPY	ETF	150.26	150.28	150.22	150.23	208127.0
2013-01-28 09:15:00	SPY	ETF	150.23	150.27	150.22	150.27	53638.0
2013-01-28 09:20:00	SPY	ETF	150.27	150.3	150.26	150.29	73601.0
2013-01-28 09:25:00	SPY	ETF	150.28	150.3	150.25	150.29	175466.0
2013-01-28 09:30:00	SPY	ETF	150.29	150.33	150.08	150.14	3619051.0
2013-01-28 09:35:00	SPY	ETF	150.14	150.17	150.04	150.14	2064931.0
2013-01-28 09:40:00	SPY	ETF	150.13	150.19	150.08	150.11	1581686.0
2013-01-28 09:45:00	SPY	ETF	150.115	150.17	150.03	150.08	1161593.0
2013-01-28 09:50:00	SPY	ETF	150.08	150.12	149.92	149.92	1542483.0
2013-01-28 09:55:00	SPY	ETF	149.925	149.98	149.92	149.93	691044.0
2013-01-28 10:00:00	SPY	ETF	149.92	149.92	149.78	149.86	3258684.0
2013-01-28 10:05:00	SPY	ETF	149.86	149.88	149.64	149.641	2088657.0
2013-01-28 10:10:00	SPY	ETF	149.64	149.7	149.61	149.619	1440330.0

> showing 50 of 41,745 rows — these rows as CSV

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