PREVIEW / etf_5min / 2011-06-10

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-06-10.parquet
  size:    932 KB
  rows:    37,681

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-06-10 04:00:00	SPY	ETF	129.07	129.07	129.0	129.0	800.0
2011-06-10 04:05:00	SPY	ETF	128.86	128.86	128.86	128.86	300.0
2011-06-10 04:10:00	SPY	ETF	128.91	128.92	128.89	128.89	4686.0
2011-06-10 04:15:00	SPY	ETF	128.93	128.93	128.93	128.93	100.0
2011-06-10 04:40:00	SPY	ETF	128.97	128.97	128.97	128.97	100.0
2011-06-10 04:45:00	SPY	ETF	128.92	128.92	128.92	128.92	400.0
2011-06-10 04:50:00	SPY	ETF	129.08	129.19	129.08	129.19	5100.0
2011-06-10 04:55:00	SPY	ETF	129.18	129.18	129.17	129.17	628.0
2011-06-10 05:25:00	SPY	ETF	129.17	129.18	129.17	129.18	300.0
2011-06-10 05:35:00	SPY	ETF	129.12	129.12	129.12	129.12	500.0
2011-06-10 06:25:00	SPY	ETF	129.14	129.14	129.14	129.14	100.0
2011-06-10 06:30:00	SPY	ETF	129.1	129.1	129.08	129.08	10100.0
2011-06-10 06:35:00	SPY	ETF	129.05	129.06	128.98	129.02	3700.0
2011-06-10 06:40:00	SPY	ETF	129.03	129.03	128.9	128.94	29700.0
2011-06-10 06:45:00	SPY	ETF	128.9	128.9	128.9	128.9	1000.0
2011-06-10 06:50:00	SPY	ETF	128.87	128.87	128.85	128.85	30060.0
2011-06-10 06:55:00	SPY	ETF	128.9	128.93	128.9	128.9	14348.0
2011-06-10 07:00:00	SPY	ETF	128.92	128.99	128.92	128.97	15700.0
2011-06-10 07:05:00	SPY	ETF	128.95	128.95	128.89	128.91	40900.0
2011-06-10 07:10:00	SPY	ETF	128.9	128.9	128.86	128.9	19468.0
2011-06-10 07:15:00	SPY	ETF	128.88	128.88	128.81	128.82	39600.0
2011-06-10 07:20:00	SPY	ETF	128.82	128.82	128.74	128.8	68495.0
2011-06-10 07:25:00	SPY	ETF	128.79	128.84	128.78	128.84	12679.0
2011-06-10 07:30:00	SPY	ETF	128.84	128.9	128.81	128.9	209710.0
2011-06-10 07:35:00	SPY	ETF	128.9	128.98	128.9	128.98	23829.0
2011-06-10 07:40:00	SPY	ETF	128.95	129.05	128.95	129.03	27082.0
2011-06-10 07:45:00	SPY	ETF	129.01	129.07	128.98	129.01	60700.0
2011-06-10 07:50:00	SPY	ETF	129.02	129.05	129.01	129.01	16450.0
2011-06-10 07:55:00	SPY	ETF	128.99	129.02	128.98	129.02	23490.0
2011-06-10 08:00:00	SPY	ETF	129.03	129.14	128.99	129.14	141066.0
2011-06-10 08:05:00	SPY	ETF	129.14	129.23	129.13	129.13	74995.0
2011-06-10 08:10:00	SPY	ETF	129.13	129.15	129.1	129.15	21200.0
2011-06-10 08:15:00	SPY	ETF	129.13	129.13	129.07	129.07	59796.0
2011-06-10 08:20:00	SPY	ETF	129.08	129.1	129.03	129.04	246851.0
2011-06-10 08:25:00	SPY	ETF	129.04	129.05	128.95	128.95	94809.0
2011-06-10 08:30:00	SPY	ETF	128.96	129.03	128.94	129.0	139093.0
2011-06-10 08:35:00	SPY	ETF	128.99	129.12	128.97	129.04	338635.0
2011-06-10 08:40:00	SPY	ETF	129.01	129.01	128.88	128.88	166577.0
2011-06-10 08:45:00	SPY	ETF	128.89	129.0	128.81	128.82	324795.0
2011-06-10 08:50:00	SPY	ETF	128.81	128.85	128.761	128.84	167506.0
2011-06-10 08:55:00	SPY	ETF	128.82	128.86	128.8	128.81	49653.0
2011-06-10 09:00:00	SPY	ETF	128.81	128.81	128.68	128.7	391835.0
2011-06-10 09:05:00	SPY	ETF	128.7	128.78	128.69	128.73	202809.0
2011-06-10 09:10:00	SPY	ETF	128.73	128.75	128.7	128.71	87516.0
2011-06-10 09:15:00	SPY	ETF	128.7	128.78	128.64	128.78	337260.0
2011-06-10 09:20:00	SPY	ETF	128.78	128.84	128.77	128.83	281162.0
2011-06-10 09:25:00	SPY	ETF	128.83	128.88	128.82	128.85	398043.0
2011-06-10 09:30:00	SPY	ETF	128.85	128.93	128.7	128.75	4414371.0
2011-06-10 09:35:00	SPY	ETF	128.75	128.78	128.51	128.5404	3426546.0
2011-06-10 09:40:00	SPY	ETF	128.54	128.63	128.44	128.54	4103152.0

> showing 50 of 37,681 rows — these rows as CSV

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