PREVIEW / etf_5min / 2010-07-30

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-07-30.parquet
  size:    755 KB
  rows:    31,279

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
2010-07-30 04:05:00	SPY	ETF	109.94	109.94	109.94	109.94	100.0
2010-07-30 04:10:00	SPY	ETF	109.86	109.86	109.86	109.86	400.0
2010-07-30 04:25:00	SPY	ETF	109.97	109.97	109.97	109.97	1500.0
2010-07-30 04:30:00	SPY	ETF	109.88	109.88	109.88	109.88	100.0
2010-07-30 05:00:00	SPY	ETF	109.89	109.89	109.87	109.87	600.0
2010-07-30 05:15:00	SPY	ETF	109.84	109.84	109.73	109.73	300.0
2010-07-30 05:20:00	SPY	ETF	109.7	109.7	109.69	109.69	994.0
2010-07-30 05:25:00	SPY	ETF	109.67	109.67	109.67	109.67	1000.0
2010-07-30 05:40:00	SPY	ETF	109.75	109.75	109.75	109.75	1000.0
2010-07-30 05:45:00	SPY	ETF	109.71	109.71	109.71	109.71	200.0
2010-07-30 05:50:00	SPY	ETF	109.7	109.7	109.7	109.7	200.0
2010-07-30 05:55:00	SPY	ETF	109.65	109.65	109.6	109.6	350.0
2010-07-30 06:00:00	SPY	ETF	109.6	109.6	109.6	109.6	100.0
2010-07-30 06:30:00	SPY	ETF	109.73	109.73	109.73	109.73	100.0
2010-07-30 06:40:00	SPY	ETF	109.76	109.76	109.76	109.76	1100.0
2010-07-30 06:45:00	SPY	ETF	109.78	109.78	109.78	109.78	100.0
2010-07-30 06:50:00	SPY	ETF	109.78	109.86	109.78	109.81	25700.0
2010-07-30 07:00:00	SPY	ETF	109.85	109.85	109.81	109.81	12900.0
2010-07-30 07:05:00	SPY	ETF	109.81	109.81	109.73	109.73	4090.0
2010-07-30 07:10:00	SPY	ETF	109.73	109.75	109.71	109.75	2880.0
2010-07-30 07:15:00	SPY	ETF	109.75	109.83	109.75	109.8	6600.0
2010-07-30 07:20:00	SPY	ETF	109.75	109.8	109.74	109.8	10200.0
2010-07-30 07:25:00	SPY	ETF	109.75	109.77	109.73	109.77	1750.0
2010-07-30 07:30:00	SPY	ETF	109.85	109.85	109.82	109.83	15500.0
2010-07-30 07:35:00	SPY	ETF	109.83	109.83	109.75	109.75	5525.0
2010-07-30 07:40:00	SPY	ETF	109.73	109.73	109.68	109.71	39019.0
2010-07-30 07:45:00	SPY	ETF	109.72	109.74	109.72	109.73	30795.0
2010-07-30 07:50:00	SPY	ETF	109.72	109.76	109.72	109.73	9690.0
2010-07-30 07:55:00	SPY	ETF	109.72	109.75	109.72	109.75	5975.0
2010-07-30 08:00:00	SPY	ETF	109.75	109.76	109.67	109.68	58850.0
2010-07-30 08:05:00	SPY	ETF	109.69	109.71	109.68	109.68	59232.0
2010-07-30 08:10:00	SPY	ETF	109.67	109.75	109.67	109.73	33233.0
2010-07-30 08:15:00	SPY	ETF	109.72	109.75	109.7	109.72	49500.0
2010-07-30 08:20:00	SPY	ETF	109.73	109.74	109.64	109.68	92025.0
2010-07-30 08:25:00	SPY	ETF	109.68	109.71	109.6	109.62	71679.0
2010-07-30 08:30:00	SPY	ETF	109.72	109.72	109.14	109.46	1892964.0
2010-07-30 08:35:00	SPY	ETF	109.46	109.65	109.26	109.31	1089419.0
2010-07-30 08:40:00	SPY	ETF	109.3	109.3	109.03	109.15	934734.0
2010-07-30 08:45:00	SPY	ETF	109.15	109.17	109.06	109.16	505169.0
2010-07-30 08:50:00	SPY	ETF	109.16	109.17	108.89	108.95	768193.0
2010-07-30 08:55:00	SPY	ETF	108.95	109.14	108.95	109.1	1001141.0
2010-07-30 09:00:00	SPY	ETF	109.1	109.18	109.1	109.11	253842.0
2010-07-30 09:05:00	SPY	ETF	109.11	109.26	109.09	109.21	181820.0
2010-07-30 09:10:00	SPY	ETF	109.2	109.23	109.12	109.19	217764.0
2010-07-30 09:15:00	SPY	ETF	109.19	109.2	109.03	109.06	243075.0
2010-07-30 09:20:00	SPY	ETF	109.06	109.14	109.06	109.13	263139.0
2010-07-30 09:25:00	SPY	ETF	109.15	109.23	109.11	109.18	729251.0
2010-07-30 09:30:00	SPY	ETF	109.17	109.42	109.16	109.32	6892902.0
2010-07-30 09:35:00	SPY	ETF	109.33	109.34	108.98	109.0	5426304.0
2010-07-30 09:40:00	SPY	ETF	109.0	109.65	108.98	109.44	9524355.0

> showing 50 of 31,279 rows — these rows as CSV

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