PREVIEW / etf_5min / 2009-08-13

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-13.parquet
  size:    708 KB
  rows:    30,399

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-13 04:05:00	SPY	ETF	101.3	101.3	101.3	101.3	100.0
2009-08-13 04:15:00	SPY	ETF	101.29	101.29	101.29	101.29	200.0
2009-08-13 04:25:00	SPY	ETF	101.4	101.4	101.4	101.4	2500.0
2009-08-13 04:30:00	SPY	ETF	101.45	101.46	101.45	101.46	300.0
2009-08-13 04:35:00	SPY	ETF	101.44	101.44	101.44	101.44	100.0
2009-08-13 04:40:00	SPY	ETF	101.48	101.55	101.48	101.55	2600.0
2009-08-13 04:50:00	SPY	ETF	101.59	101.59	101.59	101.59	100.0
2009-08-13 05:00:00	SPY	ETF	101.6	101.63	101.6	101.63	2950.0
2009-08-13 05:30:00	SPY	ETF	101.66	101.66	101.66	101.66	100.0
2009-08-13 05:45:00	SPY	ETF	101.64	101.64	101.64	101.64	100.0
2009-08-13 05:50:00	SPY	ETF	101.63	101.63	101.62	101.62	10000.0
2009-08-13 06:10:00	SPY	ETF	101.48	101.48	101.48	101.48	100.0
2009-08-13 06:15:00	SPY	ETF	101.55	101.55	101.55	101.55	100.0
2009-08-13 06:25:00	SPY	ETF	101.52	101.52	101.52	101.52	600.0
2009-08-13 06:30:00	SPY	ETF	101.52	101.52	101.52	101.52	200.0
2009-08-13 06:45:00	SPY	ETF	101.6	101.61	101.57	101.57	5900.0
2009-08-13 06:50:00	SPY	ETF	101.63	101.63	101.63	101.63	12900.0
2009-08-13 06:55:00	SPY	ETF	101.63	101.64	101.61	101.61	7700.0
2009-08-13 07:00:00	SPY	ETF	101.66	101.75	101.62	101.72	68661.0
2009-08-13 07:05:00	SPY	ETF	101.73	101.9	101.71	101.9	132400.0
2009-08-13 07:10:00	SPY	ETF	101.86	101.95	101.85	101.86	11000.0
2009-08-13 07:15:00	SPY	ETF	101.88	101.9	101.81	101.86	42205.0
2009-08-13 07:20:00	SPY	ETF	101.86	101.89	101.79	101.83	10585.0
2009-08-13 07:25:00	SPY	ETF	101.8	101.8	101.74	101.8	10800.0
2009-08-13 07:30:00	SPY	ETF	101.82	101.83	101.78	101.78	98900.0
2009-08-13 07:35:00	SPY	ETF	101.76	101.78	101.73	101.76	69715.0
2009-08-13 07:40:00	SPY	ETF	101.76	101.8	101.75	101.8	171400.0
2009-08-13 07:45:00	SPY	ETF	101.8	101.8	101.71	101.71	76408.0
2009-08-13 07:50:00	SPY	ETF	101.72	101.73	101.7	101.72	52718.0
2009-08-13 07:55:00	SPY	ETF	101.74	101.77	101.65	101.66	123791.0
2009-08-13 08:00:00	SPY	ETF	101.66	101.84	100.85	101.84	353237.0
2009-08-13 08:05:00	SPY	ETF	101.84	101.88	101.81	101.83	132319.0
2009-08-13 08:10:00	SPY	ETF	101.82	101.91	101.82	101.88	201096.0
2009-08-13 08:15:00	SPY	ETF	101.88	101.91	101.87	101.88	162798.0
2009-08-13 08:20:00	SPY	ETF	101.89	101.93	101.86	101.91	681826.0
2009-08-13 08:25:00	SPY	ETF	101.91	101.95	101.84	101.95	277595.0
2009-08-13 08:30:00	SPY	ETF	101.93	101.94	101.15	101.19	2755083.0
2009-08-13 08:35:00	SPY	ETF	101.19	101.27	101.08	101.22	1664189.0
2009-08-13 08:40:00	SPY	ETF	101.22	101.25	101.14	101.17	417624.0
2009-08-13 08:45:00	SPY	ETF	101.16	101.16	100.96	101.09	609257.0
2009-08-13 08:50:00	SPY	ETF	101.1	101.24	101.09	101.23	695875.0
2009-08-13 08:55:00	SPY	ETF	101.23	101.29	101.18	101.27	270142.0
2009-08-13 09:00:00	SPY	ETF	101.28	101.4	101.26	101.33	669213.0
2009-08-13 09:05:00	SPY	ETF	101.3	101.43	101.3	101.42	808166.0
2009-08-13 09:10:00	SPY	ETF	101.42	101.43	101.35	101.38	165389.0
2009-08-13 09:15:00	SPY	ETF	101.36	101.36	101.25	101.28	258106.0
2009-08-13 09:20:00	SPY	ETF	101.28	101.34	101.26	101.32	241746.0
2009-08-13 09:25:00	SPY	ETF	101.31	101.31	101.25	101.26	190473.0
2009-08-13 09:30:00	SPY	ETF	101.26	101.31	100.98	101.12	4632954.0
2009-08-13 09:35:00	SPY	ETF	101.13	101.16	100.81	101.06	4838619.0

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

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