PREVIEW / etf_5min / 2010-08-04

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-08-04.parquet
  size:    771 KB
  rows:    32,847

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-08-04 04:00:00	SPY	ETF	112.15	112.15	112.11	112.11	700.0
2010-08-04 04:35:00	SPY	ETF	111.9	111.9	111.85	111.85	365.0
2010-08-04 04:50:00	SPY	ETF	111.91	111.91	111.86	111.86	605.0
2010-08-04 04:55:00	SPY	ETF	111.94	111.94	111.94	111.94	200.0
2010-08-04 05:30:00	SPY	ETF	111.84	111.84	111.84	111.84	500.0
2010-08-04 05:35:00	SPY	ETF	111.8	111.8	111.8	111.8	100.0
2010-08-04 05:40:00	SPY	ETF	111.76	111.76	111.76	111.76	1950.0
2010-08-04 06:00:00	SPY	ETF	111.92	111.92	111.92	111.92	1000.0
2010-08-04 06:20:00	SPY	ETF	111.92	111.92	111.92	111.92	4900.0
2010-08-04 06:25:00	SPY	ETF	111.95	111.95	111.95	111.95	100.0
2010-08-04 06:45:00	SPY	ETF	112.04	112.08	112.04	112.08	2100.0
2010-08-04 06:55:00	SPY	ETF	112.03	112.03	112.03	112.03	100.0
2010-08-04 07:00:00	SPY	ETF	112.04	112.08	112.04	112.04	1600.0
2010-08-04 07:05:00	SPY	ETF	112.02	112.06	112.01	112.05	10000.0
2010-08-04 07:10:00	SPY	ETF	112.05	112.11	112.05	112.11	1200.0
2010-08-04 07:15:00	SPY	ETF	112.15	112.2	112.14	112.14	21320.0
2010-08-04 07:20:00	SPY	ETF	112.15	112.17	112.15	112.17	600.0
2010-08-04 07:25:00	SPY	ETF	112.17	112.21	112.17	112.17	58180.0
2010-08-04 07:30:00	SPY	ETF	112.16	112.18	112.12	112.18	74145.0
2010-08-04 07:35:00	SPY	ETF	112.19	112.19	112.17	112.17	7300.0
2010-08-04 07:40:00	SPY	ETF	112.15	112.15	112.1	112.1	105270.0
2010-08-04 07:45:00	SPY	ETF	112.1	112.11	112.06	112.1	191140.0
2010-08-04 07:50:00	SPY	ETF	112.1	112.11	112.02	112.02	31100.0
2010-08-04 07:55:00	SPY	ETF	112.05	112.07	112.04	112.07	14700.0
2010-08-04 08:00:00	SPY	ETF	112.08	112.12	112.0	112.0	449890.0
2010-08-04 08:05:00	SPY	ETF	112.02	112.03	111.97	112.0	117600.0
2010-08-04 08:10:00	SPY	ETF	112.02	112.03	111.94	112.0	82130.0
2010-08-04 08:15:00	SPY	ETF	112.0	112.5	112.0	112.4	556544.0
2010-08-04 08:20:00	SPY	ETF	112.38	112.45	112.35	112.44	252410.0
2010-08-04 08:25:00	SPY	ETF	112.44	112.65	112.39	112.62	331438.0
2010-08-04 08:30:00	SPY	ETF	112.6	112.65	112.27	112.62	588705.0
2010-08-04 08:35:00	SPY	ETF	112.61	112.66	112.5	112.5	166395.0
2010-08-04 08:40:00	SPY	ETF	112.51	112.6	112.49	112.52	160980.0
2010-08-04 08:45:00	SPY	ETF	112.53	112.56	112.51	112.53	68645.0
2010-08-04 08:50:00	SPY	ETF	112.53	112.54	112.42	112.48	62311.0
2010-08-04 08:55:00	SPY	ETF	112.43	112.54	112.43	112.53	85829.0
2010-08-04 09:00:00	SPY	ETF	112.54	112.57	112.5	112.54	71974.0
2010-08-04 09:05:00	SPY	ETF	112.54	112.66	112.52	112.61	84342.0
2010-08-04 09:10:00	SPY	ETF	112.61	112.65	112.56	112.58	81233.0
2010-08-04 09:15:00	SPY	ETF	112.58	112.64	112.57	112.59	87766.0
2010-08-04 09:20:00	SPY	ETF	112.59	112.6	112.53	112.55	75931.0
2010-08-04 09:25:00	SPY	ETF	112.54	112.56	112.51	112.53	280885.0
2010-08-04 09:30:00	SPY	ETF	112.53	112.58	112.38	112.45	3537256.0
2010-08-04 09:35:00	SPY	ETF	112.46	112.63	112.35	112.59	2388942.0
2010-08-04 09:40:00	SPY	ETF	112.59	112.69	112.41	112.67	2466332.0
2010-08-04 09:45:00	SPY	ETF	112.67	112.73	112.59	112.64	2670939.0
2010-08-04 09:50:00	SPY	ETF	112.64	112.66	112.53	112.571	2012541.0
2010-08-04 09:55:00	SPY	ETF	112.58	112.71	112.54	112.69	2227192.0
2010-08-04 10:00:00	SPY	ETF	112.7	113.03	112.695	112.89	7534932.0
2010-08-04 10:05:00	SPY	ETF	112.89	112.96	112.7	112.77	2948730.0

> showing 50 of 32,847 rows — these rows as CSV

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