PREVIEW / etf_5min / 2009-03-19

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-19.parquet
  size:    703 KB
  rows:    30,376

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-03-19 04:15:00	SPY	ETF	79.5	79.5	79.43	79.43	1100.0
2009-03-19 04:20:00	SPY	ETF	79.38	79.38	79.35	79.35	300.0
2009-03-19 04:25:00	SPY	ETF	79.36	79.36	79.27	79.28	1200.0
2009-03-19 04:30:00	SPY	ETF	79.34	79.36	79.34	79.36	1500.0
2009-03-19 04:35:00	SPY	ETF	79.51	79.52	79.51	79.52	1500.0
2009-03-19 04:40:00	SPY	ETF	79.49	79.49	79.49	79.49	400.0
2009-03-19 05:05:00	SPY	ETF	79.59	79.61	79.59	79.61	5500.0
2009-03-19 05:15:00	SPY	ETF	79.57	79.57	79.57	79.57	100.0
2009-03-19 05:20:00	SPY	ETF	79.48	79.49	79.48	79.49	2100.0
2009-03-19 05:25:00	SPY	ETF	79.52	79.52	79.52	79.52	100.0
2009-03-19 05:45:00	SPY	ETF	79.66	79.66	79.66	79.66	100.0
2009-03-19 05:50:00	SPY	ETF	79.59	79.59	79.59	79.59	2000.0
2009-03-19 05:55:00	SPY	ETF	79.56	79.56	79.56	79.56	1000.0
2009-03-19 06:00:00	SPY	ETF	79.6	79.65	79.6	79.65	16900.0
2009-03-19 06:05:00	SPY	ETF	79.65	79.65	79.62	79.63	8500.0
2009-03-19 06:10:00	SPY	ETF	79.59	79.59	79.56	79.56	35000.0
2009-03-19 06:25:00	SPY	ETF	79.7	79.7	79.58	79.58	16600.0
2009-03-19 06:30:00	SPY	ETF	79.57	79.57	79.56	79.57	53100.0
2009-03-19 06:35:00	SPY	ETF	79.59	79.59	79.57	79.57	1700.0
2009-03-19 06:50:00	SPY	ETF	79.67	79.75	79.67	79.75	2600.0
2009-03-19 06:55:00	SPY	ETF	79.76	79.83	79.76	79.79	1850.0
2009-03-19 07:00:00	SPY	ETF	79.73	79.77	79.7	79.75	60976.0
2009-03-19 07:05:00	SPY	ETF	79.75	79.84	79.73	79.79	17937.0
2009-03-19 07:10:00	SPY	ETF	79.8	79.88	79.8	79.88	15650.0
2009-03-19 07:15:00	SPY	ETF	79.85	79.99	79.8	79.99	411750.0
2009-03-19 07:20:00	SPY	ETF	79.99	80.26	79.99	80.07	228991.0
2009-03-19 07:25:00	SPY	ETF	80.06	80.1	79.99	80.03	72708.0
2009-03-19 07:30:00	SPY	ETF	80.05	80.16	80.05	80.13	211329.0
2009-03-19 07:35:00	SPY	ETF	80.13	80.34	80.09	80.34	96609.0
2009-03-19 07:40:00	SPY	ETF	80.32	80.4	80.27	80.34	76469.0
2009-03-19 07:45:00	SPY	ETF	80.34	80.34	80.12	80.32	300050.0
2009-03-19 07:50:00	SPY	ETF	80.31	80.41	80.31	80.33	118100.0
2009-03-19 07:55:00	SPY	ETF	80.33	80.41	80.24	80.41	535577.0
2009-03-19 08:00:00	SPY	ETF	80.4	80.41	80.08	80.18	217224.0
2009-03-19 08:05:00	SPY	ETF	80.17	80.28	80.0	80.0	846754.0
2009-03-19 08:10:00	SPY	ETF	80.11	80.24	80.1	80.2	354066.0
2009-03-19 08:15:00	SPY	ETF	80.2	80.24	80.11	80.21	103616.0
2009-03-19 08:20:00	SPY	ETF	80.22	80.32	80.21	80.31	71900.0
2009-03-19 08:25:00	SPY	ETF	80.3	80.4	80.24	80.38	401585.0
2009-03-19 08:30:00	SPY	ETF	80.36	80.7	80.33	80.59	1459050.0
2009-03-19 08:35:00	SPY	ETF	80.58	80.6	80.45	80.46	196136.0
2009-03-19 08:40:00	SPY	ETF	80.45	80.47	80.33	80.43	278039.0
2009-03-19 08:45:00	SPY	ETF	80.42	80.51	80.36	80.5	688204.0
2009-03-19 08:50:00	SPY	ETF	80.5	80.5	80.42	80.45	147146.0
2009-03-19 08:55:00	SPY	ETF	80.46	80.64	80.43	80.63	710238.0
2009-03-19 09:00:00	SPY	ETF	80.64	80.76	80.56	80.74	617831.0
2009-03-19 09:05:00	SPY	ETF	80.77	80.9	80.72	80.74	648662.0
2009-03-19 09:10:00	SPY	ETF	80.73	80.92	80.73	80.92	278708.0
2009-03-19 09:15:00	SPY	ETF	80.92	80.94	80.79	80.85	462183.0
2009-03-19 09:20:00	SPY	ETF	80.84	80.89	80.76	80.81	755181.0

> showing 50 of 30,376 rows — these rows as CSV

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