PREVIEW / etf_5min / 2011-03-16

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-03-16.parquet
  size:    1.0 MB
  rows:    40,918

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
2011-03-16 04:00:00	SPY	ETF	128.7	128.75	128.68	128.72	1500.0
2011-03-16 04:05:00	SPY	ETF	128.86	128.87	128.86	128.87	300.0
2011-03-16 04:20:00	SPY	ETF	128.77	128.83	128.74	128.74	900.0
2011-03-16 04:30:00	SPY	ETF	128.55	128.55	128.55	128.55	100.0
2011-03-16 04:35:00	SPY	ETF	128.6	128.68	128.6	128.68	300.0
2011-03-16 04:40:00	SPY	ETF	128.67	128.67	128.67	128.67	350.0
2011-03-16 04:50:00	SPY	ETF	128.82	128.82	128.82	128.82	100.0
2011-03-16 04:55:00	SPY	ETF	128.79	128.82	128.79	128.8	900.0
2011-03-16 05:00:00	SPY	ETF	128.72	128.72	128.72	128.72	100.0
2011-03-16 05:05:00	SPY	ETF	128.74	128.74	128.74	128.74	1000.0
2011-03-16 05:30:00	SPY	ETF	128.57	128.57	128.57	128.57	200.0
2011-03-16 05:35:00	SPY	ETF	128.31	128.31	128.31	128.31	200.0
2011-03-16 05:40:00	SPY	ETF	128.32	128.32	128.23	128.23	1200.0
2011-03-16 05:45:00	SPY	ETF	128.18	128.25	128.18	128.25	650.0
2011-03-16 05:50:00	SPY	ETF	128.38	128.38	128.31	128.31	10000.0
2011-03-16 05:55:00	SPY	ETF	128.36	128.36	128.36	128.36	500.0
2011-03-16 06:00:00	SPY	ETF	128.39	128.39	128.22	128.22	875.0
2011-03-16 06:05:00	SPY	ETF	128.12	128.12	128.11	128.11	5000.0
2011-03-16 06:10:00	SPY	ETF	128.07	128.07	128.0	128.05	1100.0
2011-03-16 06:15:00	SPY	ETF	128.07	128.09	128.01	128.01	7800.0
2011-03-16 06:20:00	SPY	ETF	128.0	128.0	127.9	127.9	7500.0
2011-03-16 06:25:00	SPY	ETF	128.08	128.18	128.08	128.16	7290.0
2011-03-16 06:30:00	SPY	ETF	128.1	128.1	128.1	128.1	100.0
2011-03-16 06:35:00	SPY	ETF	128.16	128.18	128.09	128.09	60000.0
2011-03-16 06:40:00	SPY	ETF	128.11	128.16	127.9	127.9	154300.0
2011-03-16 06:45:00	SPY	ETF	127.91	127.91	127.78	127.9	38550.0
2011-03-16 06:50:00	SPY	ETF	127.88	128.03	127.88	128.03	29900.0
2011-03-16 06:55:00	SPY	ETF	128.11	128.18	128.09	128.13	12200.0
2011-03-16 07:00:00	SPY	ETF	128.09	128.09	128.0	128.02	58800.0
2011-03-16 07:05:00	SPY	ETF	128.05	128.15	128.05	128.13	28350.0
2011-03-16 07:10:00	SPY	ETF	128.09	128.09	128.0	128.06	25940.0
2011-03-16 07:15:00	SPY	ETF	128.08	128.18	128.05	128.17	19000.0
2011-03-16 07:20:00	SPY	ETF	128.17	128.26	128.15	128.15	47383.0
2011-03-16 07:25:00	SPY	ETF	128.13	128.31	128.12	128.31	133400.0
2011-03-16 07:30:00	SPY	ETF	128.3	128.34	128.25	128.34	177175.0
2011-03-16 07:35:00	SPY	ETF	128.31	128.38	128.3	128.34	246004.0
2011-03-16 07:40:00	SPY	ETF	128.31	128.31	128.23	128.26	262730.0
2011-03-16 07:45:00	SPY	ETF	128.26	128.26	128.13	128.14	267114.0
2011-03-16 07:50:00	SPY	ETF	128.14	128.24	128.08	128.19	148474.0
2011-03-16 07:55:00	SPY	ETF	128.19	128.34	128.19	128.33	46412.0
2011-03-16 08:00:00	SPY	ETF	128.34	128.41	127.77	128.4	728907.0
2011-03-16 08:05:00	SPY	ETF	128.4	128.9	128.38	128.9	436658.0
2011-03-16 08:10:00	SPY	ETF	128.5	128.54	128.41	128.53	127926.0
2011-03-16 08:15:00	SPY	ETF	128.53	128.69	128.5	128.69	227791.0
2011-03-16 08:20:00	SPY	ETF	128.7	128.74	128.66	128.71	283466.0
2011-03-16 08:25:00	SPY	ETF	128.71	128.76	128.56	128.62	136866.0
2011-03-16 08:30:00	SPY	ETF	128.62	128.65	128.41	128.5	914384.0
2011-03-16 08:35:00	SPY	ETF	128.52	128.53	128.37	128.38	290088.0
2011-03-16 08:40:00	SPY	ETF	128.39	128.46	128.3	128.3	224434.0
2011-03-16 08:45:00	SPY	ETF	128.32	128.44	128.21	128.39	251284.0

> showing 50 of 40,918 rows — these rows as CSV

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