PREVIEW / etf_5min / 2008-04-01

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-04-01.parquet
  size:    487 KB
  rows:    23,132

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
2008-04-01 04:15:00	SPY	ETF	132.52	132.52	132.52	132.52	100.0
2008-04-01 04:30:00	SPY	ETF	132.59	132.65	132.59	132.65	700.0
2008-04-01 04:50:00	SPY	ETF	132.65	132.66	132.65	132.66	700.0
2008-04-01 05:10:00	SPY	ETF	132.63	132.63	132.63	132.63	1000.0
2008-04-01 05:30:00	SPY	ETF	132.78	132.78	132.78	132.78	200.0
2008-04-01 05:35:00	SPY	ETF	132.87	132.87	132.87	132.87	1000.0
2008-04-01 05:50:00	SPY	ETF	132.86	132.92	132.8	132.92	17800.0
2008-04-01 05:55:00	SPY	ETF	133.0	133.0	133.0	133.0	1600.0
2008-04-01 06:15:00	SPY	ETF	132.94	132.94	132.94	132.94	100.0
2008-04-01 06:20:00	SPY	ETF	132.98	133.02	132.97	133.02	16200.0
2008-04-01 06:25:00	SPY	ETF	133.0	133.08	133.0	133.08	11500.0
2008-04-01 06:35:00	SPY	ETF	132.94	133.0	132.94	133.0	11000.0
2008-04-01 06:40:00	SPY	ETF	133.08	133.11	133.08	133.11	3000.0
2008-04-01 06:50:00	SPY	ETF	133.0	133.0	133.0	133.0	1000.0
2008-04-01 06:55:00	SPY	ETF	133.0	133.0	133.0	133.0	26500.0
2008-04-01 07:00:00	SPY	ETF	133.06	133.06	133.01	133.05	55000.0
2008-04-01 07:05:00	SPY	ETF	132.92	132.96	132.92	132.94	1600.0
2008-04-01 07:10:00	SPY	ETF	132.95	132.95	132.87	132.94	5500.0
2008-04-01 07:15:00	SPY	ETF	133.0	133.0	133.0	133.0	50000.0
2008-04-01 07:20:00	SPY	ETF	133.0	133.01	133.0	133.0	84000.0
2008-04-01 07:25:00	SPY	ETF	133.0	133.0	132.9	132.96	102300.0
2008-04-01 07:30:00	SPY	ETF	132.93	132.98	132.85	132.98	71100.0
2008-04-01 07:35:00	SPY	ETF	132.97	133.12	132.97	133.12	397700.0
2008-04-01 07:40:00	SPY	ETF	133.11	133.18	133.1	133.15	159000.0
2008-04-01 07:45:00	SPY	ETF	133.16	133.18	133.15	133.15	114600.0
2008-04-01 07:50:00	SPY	ETF	133.15	133.16	133.1	133.1	65500.0
2008-04-01 07:55:00	SPY	ETF	133.1	133.1	133.0	133.07	215500.0
2008-04-01 08:00:00	SPY	ETF	133.05	133.12	132.91	133.1	1052675.0
2008-04-01 08:05:00	SPY	ETF	133.1	133.17	133.05	133.17	206100.0
2008-04-01 08:10:00	SPY	ETF	133.16	133.35	133.16	133.28	279900.0
2008-04-01 08:15:00	SPY	ETF	133.25	133.35	133.25	133.27	151600.0
2008-04-01 08:20:00	SPY	ETF	133.26	133.3	133.18	133.18	259732.0
2008-04-01 08:25:00	SPY	ETF	133.16	133.26	133.16	133.25	53300.0
2008-04-01 08:30:00	SPY	ETF	133.26	133.56	133.21	133.54	465700.0
2008-04-01 08:35:00	SPY	ETF	133.52	133.54	133.46	133.5	324200.0
2008-04-01 08:40:00	SPY	ETF	133.49	133.5	131.97	133.43	184800.0
2008-04-01 08:45:00	SPY	ETF	133.45	133.48	133.43	133.43	101400.0
2008-04-01 08:50:00	SPY	ETF	133.42	133.48	133.4	133.47	250600.0
2008-04-01 08:55:00	SPY	ETF	133.46	133.62	133.44	133.49	444900.0
2008-04-01 09:00:00	SPY	ETF	133.5	133.68	133.48	133.6	489900.0
2008-04-01 09:05:00	SPY	ETF	133.58	133.63	133.51	133.61	247004.0
2008-04-01 09:10:00	SPY	ETF	133.61	133.72	131.28	133.67	906200.0
2008-04-01 09:15:00	SPY	ETF	133.67	133.75	133.66	133.72	385550.0
2008-04-01 09:20:00	SPY	ETF	133.72	133.74	131.97	133.66	200104.0
2008-04-01 09:25:00	SPY	ETF	133.66	133.72	133.58	133.6	225700.0
2008-04-01 09:30:00	SPY	ETF	133.61	133.83	133.51	133.79	4252603.0
2008-04-01 09:35:00	SPY	ETF	133.78	134.07	133.77	133.88	4764176.0
2008-04-01 09:40:00	SPY	ETF	133.88	134.0301	133.78	133.78	3014609.0
2008-04-01 09:45:00	SPY	ETF	133.78	133.9	133.75	133.863	2445385.0
2008-04-01 09:50:00	SPY	ETF	133.88	133.9	133.73	133.83	1999445.0

> showing 50 of 23,132 rows — these rows as CSV

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