PREVIEW / etf_5min / 2011-07-20

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-20.parquet
  size:    842 KB
  rows:    35,372

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-07-20 04:00:00	SPY	ETF	133.0	133.02	133.0	133.02	214.0
2011-07-20 04:15:00	SPY	ETF	133.11	133.11	133.1	133.1	1000.0
2011-07-20 04:25:00	SPY	ETF	133.12	133.12	133.12	133.12	100.0
2011-07-20 04:30:00	SPY	ETF	133.1	133.1	133.1	133.1	700.0
2011-07-20 05:10:00	SPY	ETF	132.79	132.79	132.79	132.79	200.0
2011-07-20 05:25:00	SPY	ETF	132.98	132.98	132.98	132.98	100.0
2011-07-20 05:40:00	SPY	ETF	133.09	133.09	133.09	133.09	200.0
2011-07-20 06:00:00	SPY	ETF	133.02	133.02	133.02	133.02	1000.0
2011-07-20 06:05:00	SPY	ETF	132.99	132.99	132.99	132.99	250.0
2011-07-20 06:15:00	SPY	ETF	133.01	133.01	133.01	133.01	335.0
2011-07-20 06:20:00	SPY	ETF	133.01	133.01	133.01	133.01	100.0
2011-07-20 06:30:00	SPY	ETF	133.15	133.2	133.15	133.2	600.0
2011-07-20 06:35:00	SPY	ETF	133.23	133.34	133.14	133.34	3040.0
2011-07-20 06:40:00	SPY	ETF	133.31	133.35	133.31	133.32	800.0
2011-07-20 06:45:00	SPY	ETF	133.31	133.31	133.31	133.31	100.0
2011-07-20 06:55:00	SPY	ETF	133.31	133.33	133.29	133.3	12050.0
2011-07-20 07:00:00	SPY	ETF	133.32	133.34	133.24	133.24	19300.0
2011-07-20 07:05:00	SPY	ETF	133.29	133.29	133.24	133.24	2400.0
2011-07-20 07:10:00	SPY	ETF	133.27	133.27	133.25	133.27	7100.0
2011-07-20 07:15:00	SPY	ETF	133.29	133.38	133.29	133.37	303430.0
2011-07-20 07:20:00	SPY	ETF	133.38	133.38	133.31	133.32	101748.0
2011-07-20 07:25:00	SPY	ETF	133.29	133.41	133.29	133.4	83134.0
2011-07-20 07:30:00	SPY	ETF	133.4	133.43	133.35	133.36	106210.0
2011-07-20 07:35:00	SPY	ETF	133.38	133.42	133.38	133.38	32900.0
2011-07-20 07:40:00	SPY	ETF	133.37	133.37	133.3	133.33	301150.0
2011-07-20 07:45:00	SPY	ETF	133.35	133.35	133.26	133.33	73400.0
2011-07-20 07:50:00	SPY	ETF	133.31	133.33	133.29	133.29	14995.0
2011-07-20 07:55:00	SPY	ETF	133.28	133.28	133.21	133.25	10532.0
2011-07-20 08:00:00	SPY	ETF	133.3	133.34	133.23	133.28	1608170.0
2011-07-20 08:05:00	SPY	ETF	133.26	133.26	133.16	133.16	124439.0
2011-07-20 08:10:00	SPY	ETF	133.19	133.2	133.15	133.18	248180.0
2011-07-20 08:15:00	SPY	ETF	133.17	133.21	133.12	133.21	81349.0
2011-07-20 08:20:00	SPY	ETF	133.22	133.27	133.22	133.25	89085.0
2011-07-20 08:25:00	SPY	ETF	133.25	133.25	133.21	133.25	43449.0
2011-07-20 08:30:00	SPY	ETF	133.24	133.3	133.24	133.27	233418.0
2011-07-20 08:35:00	SPY	ETF	133.27	133.32	133.25	133.31	181323.0
2011-07-20 08:40:00	SPY	ETF	133.3	133.32	133.21	133.22	65005.0
2011-07-20 08:45:00	SPY	ETF	133.23	133.29	133.21	133.24	647371.0
2011-07-20 08:50:00	SPY	ETF	133.23	133.28	133.21	133.21	123046.0
2011-07-20 08:55:00	SPY	ETF	133.22	133.23	133.19	133.22	141990.0
2011-07-20 09:00:00	SPY	ETF	133.22	133.28	133.21	133.27	68507.0
2011-07-20 09:05:00	SPY	ETF	133.27	133.28	133.23	133.27	74073.0
2011-07-20 09:10:00	SPY	ETF	133.26	133.27	133.2	133.23	76990.0
2011-07-20 09:15:00	SPY	ETF	133.23	133.25	133.15	133.16	219365.0
2011-07-20 09:20:00	SPY	ETF	133.16	133.19	133.14	133.16	174118.0
2011-07-20 09:25:00	SPY	ETF	133.17	133.19	133.06	133.08	1216413.0
2011-07-20 09:30:00	SPY	ETF	133.07	133.15	132.93	132.95	4597065.0
2011-07-20 09:35:00	SPY	ETF	132.94	133.02	132.86	132.97	2793224.0
2011-07-20 09:40:00	SPY	ETF	132.97	132.98	132.76	132.84	2116888.0
2011-07-20 09:45:00	SPY	ETF	132.83	132.88	132.75	132.75	2495429.0

> showing 50 of 35,372 rows — these rows as CSV

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