PREVIEW / etf_5min / 2009-08-27

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-27.parquet
  size:    736 KB
  rows:    29,484

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
2009-08-27 04:10:00	SPY	ETF	103.3	103.3	103.3	103.3	100.0
2009-08-27 04:15:00	SPY	ETF	103.33	103.33	103.33	103.33	500.0
2009-08-27 04:35:00	SPY	ETF	103.25	103.25	103.25	103.25	500.0
2009-08-27 05:00:00	SPY	ETF	103.2	103.2	103.2	103.2	100.0
2009-08-27 05:15:00	SPY	ETF	103.22	103.22	103.21	103.21	4000.0
2009-08-27 05:20:00	SPY	ETF	103.21	103.21	103.21	103.21	1000.0
2009-08-27 05:25:00	SPY	ETF	103.25	103.25	103.25	103.25	200.0
2009-08-27 06:20:00	SPY	ETF	103.22	103.22	103.22	103.22	2000.0
2009-08-27 06:30:00	SPY	ETF	103.2	103.2	103.15	103.15	700.0
2009-08-27 06:40:00	SPY	ETF	103.0	103.0	103.0	103.0	1500.0
2009-08-27 06:45:00	SPY	ETF	102.95	102.95	102.92	102.92	2200.0
2009-08-27 06:50:00	SPY	ETF	102.98	102.98	102.98	102.98	100.0
2009-08-27 07:00:00	SPY	ETF	102.99	103.01	102.96	103.01	10250.0
2009-08-27 07:05:00	SPY	ETF	102.97	102.99	102.97	102.99	12600.0
2009-08-27 07:10:00	SPY	ETF	103.0	103.0	103.0	103.0	1000.0
2009-08-27 07:15:00	SPY	ETF	103.03	103.06	103.03	103.04	7500.0
2009-08-27 07:20:00	SPY	ETF	103.06	103.11	103.06	103.06	29634.0
2009-08-27 07:25:00	SPY	ETF	103.07	103.15	103.07	103.15	160400.0
2009-08-27 07:30:00	SPY	ETF	103.17	103.2	103.13	103.13	104600.0
2009-08-27 07:35:00	SPY	ETF	103.15	103.16	103.11	103.11	105760.0
2009-08-27 07:40:00	SPY	ETF	103.11	103.14	103.11	103.13	15900.0
2009-08-27 07:45:00	SPY	ETF	103.12	103.15	103.11	103.14	59650.0
2009-08-27 07:50:00	SPY	ETF	103.2	103.21	103.2	103.2	39940.0
2009-08-27 07:55:00	SPY	ETF	103.14	103.14	103.1	103.12	59489.0
2009-08-27 08:00:00	SPY	ETF	103.12	103.21	103.12	103.15	697380.0
2009-08-27 08:05:00	SPY	ETF	103.15	103.2	103.14	103.18	59837.0
2009-08-27 08:10:00	SPY	ETF	103.18	103.3	103.18	103.27	185948.0
2009-08-27 08:15:00	SPY	ETF	103.28	103.29	103.14	103.19	125462.0
2009-08-27 08:20:00	SPY	ETF	103.2	103.25	103.19	103.23	46568.0
2009-08-27 08:25:00	SPY	ETF	103.23	103.46	103.23	103.41	586100.0
2009-08-27 08:30:00	SPY	ETF	103.43	103.55	102.99	103.08	2226856.0
2009-08-27 08:35:00	SPY	ETF	103.09	103.29	103.05	103.26	443149.0
2009-08-27 08:40:00	SPY	ETF	103.27	103.37	103.25	103.32	349081.0
2009-08-27 08:45:00	SPY	ETF	103.32	103.47	103.28	103.28	695108.0
2009-08-27 08:50:00	SPY	ETF	103.29	103.32	103.18	103.18	382913.0
2009-08-27 08:55:00	SPY	ETF	103.19	103.25	103.18	103.22	270961.0
2009-08-27 09:00:00	SPY	ETF	103.21	103.27	103.2	103.24	161070.0
2009-08-27 09:05:00	SPY	ETF	103.24	103.24	103.06	103.11	367419.0
2009-08-27 09:10:00	SPY	ETF	103.12	103.21	103.09	103.18	137673.0
2009-08-27 09:15:00	SPY	ETF	103.17	103.18	103.17	103.17	31184.0
2009-08-27 09:20:00	SPY	ETF	103.16	103.16	103.1	103.13	164577.0
2009-08-27 09:25:00	SPY	ETF	103.12	103.17	103.09	103.11	455673.0
2009-08-27 09:30:00	SPY	ETF	103.11	103.15	102.78	102.78	3081807.0
2009-08-27 09:35:00	SPY	ETF	102.79	102.93	102.74	102.78	4511203.0
2009-08-27 09:40:00	SPY	ETF	102.77	102.775	102.53	102.62	6564379.0
2009-08-27 09:45:00	SPY	ETF	102.62	102.7	102.4601	102.57	4258380.0
2009-08-27 09:50:00	SPY	ETF	102.565	102.58	102.35	102.44	4318449.0
2009-08-27 09:55:00	SPY	ETF	102.44	102.49	102.24	102.25	3235837.0
2009-08-27 10:00:00	SPY	ETF	102.24	102.242	102.03	102.14	6352722.0
2009-08-27 10:05:00	SPY	ETF	102.13	102.16	101.98	101.99	6901433.0

> showing 50 of 29,484 rows — these rows as CSV

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