PREVIEW / etf_5min / 2010-04-27

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-04-27.parquet
  size:    904 KB
  rows:    36,107

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-04-27 04:20:00	SPY	ETF	121.2	121.2	121.2	121.2	129.0
2010-04-27 04:30:00	SPY	ETF	121.24	121.24	121.24	121.24	1000.0
2010-04-27 04:50:00	SPY	ETF	121.29	121.3	121.25	121.25	1335.0
2010-04-27 05:00:00	SPY	ETF	121.27	121.27	121.27	121.27	2000.0
2010-04-27 05:05:00	SPY	ETF	121.3	121.3	121.3	121.3	1000.0
2010-04-27 05:10:00	SPY	ETF	121.3	121.3	121.3	121.3	100.0
2010-04-27 05:20:00	SPY	ETF	121.23	121.23	121.21	121.21	300.0
2010-04-27 05:25:00	SPY	ETF	121.2	121.2	121.2	121.2	200.0
2010-04-27 05:30:00	SPY	ETF	121.15	121.15	121.13	121.13	500.0
2010-04-27 05:40:00	SPY	ETF	121.1	121.1	121.04	121.04	2200.0
2010-04-27 05:55:00	SPY	ETF	121.1	121.1	121.02	121.02	10500.0
2010-04-27 06:00:00	SPY	ETF	121.01	121.01	121.0	121.0	550.0
2010-04-27 06:05:00	SPY	ETF	120.92	120.92	120.92	120.92	100.0
2010-04-27 06:15:00	SPY	ETF	120.98	120.98	120.93	120.93	5600.0
2010-04-27 06:20:00	SPY	ETF	120.92	120.93	120.92	120.93	3100.0
2010-04-27 06:25:00	SPY	ETF	120.94	120.94	120.94	120.94	100.0
2010-04-27 06:30:00	SPY	ETF	120.85	120.85	120.79	120.79	2000.0
2010-04-27 06:35:00	SPY	ETF	120.79	120.79	120.79	120.79	18300.0
2010-04-27 06:45:00	SPY	ETF	120.75	120.75	120.73	120.73	10100.0
2010-04-27 06:50:00	SPY	ETF	120.77	120.78	120.7	120.7	52000.0
2010-04-27 06:55:00	SPY	ETF	120.8	120.8	120.73	120.75	32500.0
2010-04-27 07:00:00	SPY	ETF	120.79	120.82	120.76	120.81	50498.0
2010-04-27 07:05:00	SPY	ETF	120.84	120.91	120.82	120.85	126000.0
2010-04-27 07:10:00	SPY	ETF	120.89	120.89	120.85	120.87	16910.0
2010-04-27 07:15:00	SPY	ETF	120.87	120.87	120.85	120.86	11300.0
2010-04-27 07:20:00	SPY	ETF	120.91	120.91	120.82	120.82	88300.0
2010-04-27 07:25:00	SPY	ETF	120.83	120.84	120.79	120.8	72035.0
2010-04-27 07:30:00	SPY	ETF	120.8	120.86	120.8	120.86	38400.0
2010-04-27 07:35:00	SPY	ETF	120.9	120.96	120.9	120.96	20975.0
2010-04-27 07:40:00	SPY	ETF	120.96	120.96	120.91	120.93	76110.0
2010-04-27 07:45:00	SPY	ETF	120.93	120.94	120.87	120.88	29613.0
2010-04-27 07:50:00	SPY	ETF	120.88	120.91	120.87	120.9	65389.0
2010-04-27 07:55:00	SPY	ETF	120.89	120.89	120.78	120.78	70320.0
2010-04-27 08:00:00	SPY	ETF	120.8	120.91	120.77	120.84	111502.0
2010-04-27 08:05:00	SPY	ETF	120.84	120.9	120.84	120.89	88638.0
2010-04-27 08:10:00	SPY	ETF	120.89	120.9	120.83	120.83	29297.0
2010-04-27 08:15:00	SPY	ETF	120.83	120.85	120.8	120.81	43216.0
2010-04-27 08:20:00	SPY	ETF	120.82	120.87	120.78	120.81	80328.0
2010-04-27 08:25:00	SPY	ETF	120.81	120.82	120.74	120.77	110898.0
2010-04-27 08:30:00	SPY	ETF	120.77	120.84	120.75	120.82	71847.0
2010-04-27 08:35:00	SPY	ETF	120.82	120.82	120.75	120.76	71667.0
2010-04-27 08:40:00	SPY	ETF	120.75	120.76	120.74	120.75	66200.0
2010-04-27 08:45:00	SPY	ETF	120.75	120.77	120.71	120.76	223235.0
2010-04-27 08:50:00	SPY	ETF	120.76	120.79	120.72	120.74	466870.0
2010-04-27 08:55:00	SPY	ETF	120.75	120.82	120.74	120.79	236916.0
2010-04-27 09:00:00	SPY	ETF	120.78	120.78	120.67	120.72	378754.0
2010-04-27 09:05:00	SPY	ETF	120.72	120.76	120.57	120.63	305835.0
2010-04-27 09:10:00	SPY	ETF	120.63	120.66	120.62	120.64	284656.0
2010-04-27 09:15:00	SPY	ETF	120.64	120.71	120.63	120.71	143798.0
2010-04-27 09:20:00	SPY	ETF	120.7	120.74	120.68	120.7	248017.0

> showing 50 of 36,107 rows — these rows as CSV

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