PREVIEW / etf_5min / 2009-01-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-09.parquet
  size:    611 KB
  rows:    26,257

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-01-09 04:15:00	SPY	ETF	90.54	90.57	90.54	90.57	201.0
2009-01-09 04:20:00	SPY	ETF	90.61	90.67	90.61	90.67	500.0
2009-01-09 04:25:00	SPY	ETF	90.69	90.69	90.66	90.66	200.0
2009-01-09 04:30:00	SPY	ETF	90.57	90.57	90.57	90.57	100.0
2009-01-09 04:35:00	SPY	ETF	90.62	90.62	90.62	90.62	200.0
2009-01-09 04:45:00	SPY	ETF	90.56	90.56	90.52	90.52	1000.0
2009-01-09 04:50:00	SPY	ETF	90.54	90.54	90.54	90.54	100.0
2009-01-09 05:20:00	SPY	ETF	90.62	90.62	90.62	90.62	200.0
2009-01-09 05:30:00	SPY	ETF	90.7	90.7	90.7	90.7	2500.0
2009-01-09 05:45:00	SPY	ETF	90.79	90.79	90.79	90.79	800.0
2009-01-09 06:05:00	SPY	ETF	90.85	90.85	90.85	90.85	100.0
2009-01-09 06:15:00	SPY	ETF	90.83	90.83	90.83	90.83	294.0
2009-01-09 06:30:00	SPY	ETF	90.64	90.65	90.62	90.65	9000.0
2009-01-09 06:35:00	SPY	ETF	90.63	90.63	90.63	90.63	100.0
2009-01-09 07:00:00	SPY	ETF	90.74	90.74	90.72	90.72	1200.0
2009-01-09 07:05:00	SPY	ETF	90.72	90.72	90.71	90.71	15700.0
2009-01-09 07:10:00	SPY	ETF	90.77	90.81	90.73	90.74	8600.0
2009-01-09 07:15:00	SPY	ETF	90.77	90.77	90.77	90.77	1369.0
2009-01-09 07:20:00	SPY	ETF	90.79	90.85	90.79	90.85	1676.0
2009-01-09 07:25:00	SPY	ETF	90.87	90.89	90.85	90.89	1416.0
2009-01-09 07:30:00	SPY	ETF	90.85	90.85	90.71	90.72	30726.0
2009-01-09 07:35:00	SPY	ETF	90.72	90.72	90.69	90.69	6757.0
2009-01-09 07:40:00	SPY	ETF	90.69	90.79	90.69	90.79	3069.0
2009-01-09 07:45:00	SPY	ETF	90.8	90.88	90.8	90.81	28714.0
2009-01-09 07:50:00	SPY	ETF	90.84	90.9	90.83	90.85	56697.0
2009-01-09 07:55:00	SPY	ETF	90.86	90.88	90.83	90.84	2600.0
2009-01-09 08:00:00	SPY	ETF	90.83	90.85	90.74	90.77	34757.0
2009-01-09 08:05:00	SPY	ETF	90.77	90.77	90.66	90.75	122948.0
2009-01-09 08:10:00	SPY	ETF	90.76	91.0	90.72	90.88	129215.0
2009-01-09 08:15:00	SPY	ETF	90.87	90.88	90.75	90.83	136053.0
2009-01-09 08:20:00	SPY	ETF	90.82	90.96	90.8	90.82	242816.0
2009-01-09 08:25:00	SPY	ETF	90.82	90.84	90.7	90.75	523442.0
2009-01-09 08:30:00	SPY	ETF	90.8	91.85	90.65	91.47	5679261.0
2009-01-09 08:35:00	SPY	ETF	91.47	91.56	91.0	91.0	1589611.0
2009-01-09 08:40:00	SPY	ETF	91.0	91.23	90.92	91.15	1193051.0
2009-01-09 08:45:00	SPY	ETF	91.19	91.38	91.15	91.23	627668.0
2009-01-09 08:50:00	SPY	ETF	91.24	91.42	91.15	91.24	366422.0
2009-01-09 08:55:00	SPY	ETF	91.23	91.51	91.23	91.45	306063.0
2009-01-09 09:00:00	SPY	ETF	91.44	91.46	91.21	91.22	293951.0
2009-01-09 09:05:00	SPY	ETF	91.22	91.41	91.2	91.37	216235.0
2009-01-09 09:10:00	SPY	ETF	91.39	91.41	91.28	91.4	78124.0
2009-01-09 09:15:00	SPY	ETF	91.37	91.41	91.28	91.32	112712.0
2009-01-09 09:20:00	SPY	ETF	91.31	91.32	91.1	91.15	327476.0
2009-01-09 09:25:00	SPY	ETF	91.14	91.24	91.12	91.17	318519.0
2009-01-09 09:30:00	SPY	ETF	91.16	91.32	90.81	90.89	5931532.0
2009-01-09 09:35:00	SPY	ETF	90.89	90.9	90.48	90.57	6106636.0
2009-01-09 09:40:00	SPY	ETF	90.57	90.59	89.99	90.09	9264166.0
2009-01-09 09:45:00	SPY	ETF	90.09	90.1	89.6	89.61	9697956.0
2009-01-09 09:50:00	SPY	ETF	89.61	89.67	89.3	89.4092	8559696.0
2009-01-09 09:55:00	SPY	ETF	89.4	89.48	89.14	89.42	9617647.0

> showing 50 of 26,257 rows — these rows as CSV

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