PREVIEW / etf_5min / 2010-07-23

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-07-23.parquet
  size:    800 KB
  rows:    32,482

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-23 04:00:00	SPY	ETF	109.71	109.71	109.71	109.71	100.0
2010-07-23 04:05:00	SPY	ETF	109.69	109.8	109.69	109.8	2400.0
2010-07-23 04:10:00	SPY	ETF	109.85	109.85	109.85	109.85	300.0
2010-07-23 04:30:00	SPY	ETF	109.91	109.93	109.85	109.89	4100.0
2010-07-23 04:35:00	SPY	ETF	109.94	109.94	109.94	109.94	1000.0
2010-07-23 04:45:00	SPY	ETF	109.85	109.85	109.85	109.85	5000.0
2010-07-23 05:05:00	SPY	ETF	109.64	109.64	109.64	109.64	1950.0
2010-07-23 05:40:00	SPY	ETF	109.67	109.67	109.67	109.67	100.0
2010-07-23 05:50:00	SPY	ETF	109.65	109.67	109.65	109.67	20200.0
2010-07-23 05:55:00	SPY	ETF	109.7	109.7	109.7	109.7	100.0
2010-07-23 06:00:00	SPY	ETF	109.67	109.67	109.65	109.65	400.0
2010-07-23 06:05:00	SPY	ETF	109.59	109.59	109.59	109.59	100.0
2010-07-23 06:10:00	SPY	ETF	109.65	109.65	109.65	109.65	20000.0
2010-07-23 06:25:00	SPY	ETF	109.63	109.63	109.63	109.63	3000.0
2010-07-23 06:30:00	SPY	ETF	109.65	109.65	109.65	109.65	2000.0
2010-07-23 06:35:00	SPY	ETF	109.65	109.65	109.65	109.65	100.0
2010-07-23 06:40:00	SPY	ETF	109.7	109.75	109.7	109.75	300.0
2010-07-23 06:45:00	SPY	ETF	109.75	109.81	109.75	109.81	29125.0
2010-07-23 06:50:00	SPY	ETF	109.88	109.91	109.81	109.81	7800.0
2010-07-23 06:55:00	SPY	ETF	109.75	109.75	109.7	109.7	2200.0
2010-07-23 07:00:00	SPY	ETF	109.81	109.91	109.81	109.89	47025.0
2010-07-23 07:05:00	SPY	ETF	109.89	109.89	109.85	109.88	12480.0
2010-07-23 07:10:00	SPY	ETF	109.81	109.9	109.8	109.9	600.0
2010-07-23 07:15:00	SPY	ETF	109.86	109.88	109.86	109.88	1125.0
2010-07-23 07:20:00	SPY	ETF	109.84	109.84	109.66	109.7	359260.0
2010-07-23 07:25:00	SPY	ETF	109.71	109.71	109.66	109.7	179380.0
2010-07-23 07:30:00	SPY	ETF	109.71	109.75	109.71	109.71	94070.0
2010-07-23 07:35:00	SPY	ETF	109.71	109.77	109.7	109.77	106110.0
2010-07-23 07:40:00	SPY	ETF	109.76	109.77	109.73	109.75	54799.0
2010-07-23 07:45:00	SPY	ETF	109.79	109.79	109.77	109.77	7800.0
2010-07-23 07:50:00	SPY	ETF	109.74	109.77	109.73	109.75	234760.0
2010-07-23 07:55:00	SPY	ETF	109.76	109.76	109.72	109.72	2700.0
2010-07-23 08:00:00	SPY	ETF	109.72	109.78	109.71	109.71	1237796.0
2010-07-23 08:05:00	SPY	ETF	109.72	109.75	109.64	109.67	28900.0
2010-07-23 08:10:00	SPY	ETF	109.67	109.69	109.65	109.67	74180.0
2010-07-23 08:15:00	SPY	ETF	109.67	109.77	109.67	109.73	80340.0
2010-07-23 08:20:00	SPY	ETF	109.72	109.85	109.72	109.83	142350.0
2010-07-23 08:25:00	SPY	ETF	109.83	109.85	109.77	109.83	193361.0
2010-07-23 08:30:00	SPY	ETF	109.83	109.85	109.8	109.8	45155.0
2010-07-23 08:35:00	SPY	ETF	109.82	109.83	109.71	109.74	98765.0
2010-07-23 08:40:00	SPY	ETF	109.75	109.75	109.67	109.68	88200.0
2010-07-23 08:45:00	SPY	ETF	109.69	109.72	109.69	109.71	205299.0
2010-07-23 08:50:00	SPY	ETF	109.7	109.71	109.63	109.66	241820.0
2010-07-23 08:55:00	SPY	ETF	109.65	109.68	109.58	109.63	264938.0
2010-07-23 09:00:00	SPY	ETF	109.64	109.64	109.57	109.63	146081.0
2010-07-23 09:05:00	SPY	ETF	109.63	109.7	109.62	109.69	96233.0
2010-07-23 09:10:00	SPY	ETF	109.7	109.71	109.25	109.38	1243530.0
2010-07-23 09:15:00	SPY	ETF	109.37	109.42	109.14	109.33	1447278.0
2010-07-23 09:20:00	SPY	ETF	109.33	109.37	109.19	109.28	569722.0
2010-07-23 09:25:00	SPY	ETF	109.28	109.34	109.2	109.25	473488.0

> showing 50 of 32,482 rows — these rows as CSV

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