PREVIEW / etf_5min / 2009-08-14

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-14.parquet
  size:    688 KB
  rows:    29,390

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-14 04:05:00	SPY	ETF	101.9	101.94	101.9	101.94	5300.0
2009-08-14 04:15:00	SPY	ETF	101.84	101.85	101.84	101.85	200.0
2009-08-14 05:15:00	SPY	ETF	101.78	101.78	101.78	101.78	2000.0
2009-08-14 05:40:00	SPY	ETF	101.74	101.74	101.64	101.64	3100.0
2009-08-14 05:45:00	SPY	ETF	101.62	101.62	101.6	101.6	1000.0
2009-08-14 06:15:00	SPY	ETF	101.71	101.71	101.71	101.71	5500.0
2009-08-14 06:25:00	SPY	ETF	101.67	101.67	101.67	101.67	2500.0
2009-08-14 06:30:00	SPY	ETF	101.65	101.65	101.65	101.65	25000.0
2009-08-14 06:35:00	SPY	ETF	101.65	101.7	101.65	101.7	40000.0
2009-08-14 06:40:00	SPY	ETF	101.65	101.65	101.62	101.62	40000.0
2009-08-14 06:45:00	SPY	ETF	101.65	101.68	101.65	101.68	12000.0
2009-08-14 06:50:00	SPY	ETF	101.7	101.7	101.67	101.67	17843.0
2009-08-14 06:55:00	SPY	ETF	101.67	101.68	101.64	101.64	21200.0
2009-08-14 07:00:00	SPY	ETF	101.62	101.67	101.62	101.63	20000.0
2009-08-14 07:05:00	SPY	ETF	101.68	101.77	101.68	101.7	3552.0
2009-08-14 07:10:00	SPY	ETF	101.77	101.77	101.71	101.71	7500.0
2009-08-14 07:15:00	SPY	ETF	101.74	101.75	101.72	101.72	32000.0
2009-08-14 07:20:00	SPY	ETF	101.77	101.77	101.77	101.77	800.0
2009-08-14 07:25:00	SPY	ETF	101.73	101.82	101.72	101.78	22450.0
2009-08-14 07:30:00	SPY	ETF	101.82	101.85	101.78	101.85	9700.0
2009-08-14 07:35:00	SPY	ETF	101.86	101.89	101.82	101.84	27349.0
2009-08-14 07:40:00	SPY	ETF	101.89	101.89	101.84	101.84	49854.0
2009-08-14 07:45:00	SPY	ETF	101.84	101.85	101.78	101.78	67651.0
2009-08-14 07:50:00	SPY	ETF	101.78	101.8	101.75	101.75	100137.0
2009-08-14 07:55:00	SPY	ETF	101.77	101.79	101.76	101.78	43171.0
2009-08-14 08:00:00	SPY	ETF	101.77	101.81	101.77	101.8	24965.0
2009-08-14 08:05:00	SPY	ETF	101.79	101.87	101.78	101.84	146938.0
2009-08-14 08:10:00	SPY	ETF	101.83	101.89	101.79	101.84	124237.0
2009-08-14 08:15:00	SPY	ETF	101.85	101.87	101.83	101.87	20632.0
2009-08-14 08:20:00	SPY	ETF	101.87	101.89	101.87	101.88	64596.0
2009-08-14 08:25:00	SPY	ETF	101.88	101.89	101.79	101.84	255470.0
2009-08-14 08:30:00	SPY	ETF	101.85	101.88	101.64	101.68	551231.0
2009-08-14 08:35:00	SPY	ETF	101.69	101.76	101.67	101.71	254112.0
2009-08-14 08:40:00	SPY	ETF	101.71	101.83	101.69	101.73	1148589.0
2009-08-14 08:45:00	SPY	ETF	101.75	101.76	101.66	101.66	171551.0
2009-08-14 08:50:00	SPY	ETF	101.65	101.65	101.49	101.59	723083.0
2009-08-14 08:55:00	SPY	ETF	101.58	101.58	101.5	101.56	1377620.0
2009-08-14 09:00:00	SPY	ETF	101.55	101.6	101.52	101.58	108993.0
2009-08-14 09:05:00	SPY	ETF	101.58	101.67	101.58	101.64	170039.0
2009-08-14 09:10:00	SPY	ETF	101.64	101.75	101.64	101.75	225421.0
2009-08-14 09:15:00	SPY	ETF	101.74	101.76	101.46	101.63	1007716.0
2009-08-14 09:20:00	SPY	ETF	101.63	101.63	101.46	101.47	288103.0
2009-08-14 09:25:00	SPY	ETF	101.46	101.53	101.41	101.53	295648.0
2009-08-14 09:30:00	SPY	ETF	101.52	101.6	101.3	101.37	3271800.0
2009-08-14 09:35:00	SPY	ETF	101.36	101.37	101.16	101.27	3525301.0
2009-08-14 09:40:00	SPY	ETF	101.28	101.28	101.1	101.1	3552755.0
2009-08-14 09:45:00	SPY	ETF	101.1	101.145	100.91	101.05	5045277.0
2009-08-14 09:50:00	SPY	ETF	101.04	101.17	100.9	100.94	3087975.0
2009-08-14 09:55:00	SPY	ETF	100.94	101.06	100.5	100.6	10293631.0
2009-08-14 10:00:00	SPY	ETF	100.61	100.61	100.28	100.39	6771031.0

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

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