PREVIEW / etf_5min / 2013-01-04

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-04.parquet
  size:    971 KB
  rows:    41,467

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
2013-01-04 04:35:00	SPY	ETF	145.79	145.79	145.79	145.79	2600.0
2013-01-04 04:40:00	SPY	ETF	145.75	145.75	145.75	145.75	100.0
2013-01-04 05:10:00	SPY	ETF	145.72	145.72	145.72	145.72	3200.0
2013-01-04 05:25:00	SPY	ETF	145.68	145.68	145.68	145.68	1000.0
2013-01-04 05:30:00	SPY	ETF	145.7	145.7	145.7	145.7	1100.0
2013-01-04 05:35:00	SPY	ETF	145.7	145.71	145.7	145.71	2400.0
2013-01-04 05:40:00	SPY	ETF	145.74	145.74	145.74	145.74	1000.0
2013-01-04 05:45:00	SPY	ETF	145.71	145.71	145.71	145.71	100.0
2013-01-04 05:55:00	SPY	ETF	145.74	145.77	145.69	145.77	3032.0
2013-01-04 06:00:00	SPY	ETF	145.77	145.77	145.72	145.72	400.0
2013-01-04 06:30:00	SPY	ETF	145.72	145.72	145.72	145.72	6500.0
2013-01-04 06:45:00	SPY	ETF	145.66	145.66	145.66	145.66	150.0
2013-01-04 06:55:00	SPY	ETF	145.68	145.68	145.68	145.68	300.0
2013-01-04 07:00:00	SPY	ETF	145.73	145.73	145.73	145.73	300.0
2013-01-04 07:05:00	SPY	ETF	145.76	145.77	145.76	145.77	2400.0
2013-01-04 07:10:00	SPY	ETF	145.76	145.79	145.74	145.79	4450.0
2013-01-04 07:15:00	SPY	ETF	145.79	145.79	145.77	145.79	3900.0
2013-01-04 07:20:00	SPY	ETF	145.79	145.79	145.77	145.77	10500.0
2013-01-04 07:25:00	SPY	ETF	145.78	145.79	145.77	145.79	10600.0
2013-01-04 07:30:00	SPY	ETF	145.77	145.78	145.77	145.77	49690.0
2013-01-04 07:35:00	SPY	ETF	145.77	145.79	145.76	145.76	6400.0
2013-01-04 07:40:00	SPY	ETF	145.75	145.79	145.7	145.7	9100.0
2013-01-04 07:45:00	SPY	ETF	145.71	145.72	145.66	145.68	22795.0
2013-01-04 07:50:00	SPY	ETF	145.72	145.73	145.71	145.71	40600.0
2013-01-04 07:55:00	SPY	ETF	145.72	145.73	145.66	145.69	81001.0
2013-01-04 08:00:00	SPY	ETF	145.68	145.74	145.5	145.69	152107.0
2013-01-04 08:05:00	SPY	ETF	145.77	145.77	145.66	145.72	369101.0
2013-01-04 08:10:00	SPY	ETF	145.7	145.74	145.68	145.69	81100.0
2013-01-04 08:15:00	SPY	ETF	145.71	145.71	145.66	145.71	35750.0
2013-01-04 08:20:00	SPY	ETF	145.71	145.91	145.71	145.89	527620.0
2013-01-04 08:25:00	SPY	ETF	145.89	145.93	145.78	145.93	1081180.0
2013-01-04 08:30:00	SPY	ETF	145.84	146.04	145.49	145.92	1236191.0
2013-01-04 08:35:00	SPY	ETF	145.9	146.1	145.87	145.89	491182.0
2013-01-04 08:40:00	SPY	ETF	145.89	145.91	145.83	145.84	214033.0
2013-01-04 08:45:00	SPY	ETF	145.83	146.0	145.82	146.0	193632.0
2013-01-04 08:50:00	SPY	ETF	145.99	146.1	145.94	146.05	221020.0
2013-01-04 08:55:00	SPY	ETF	146.05	146.08	145.97	145.99	188496.0
2013-01-04 09:00:00	SPY	ETF	146.0	146.06	145.99	146.0	108194.0
2013-01-04 09:05:00	SPY	ETF	145.99	146.07	145.98	146.01	153427.0
2013-01-04 09:10:00	SPY	ETF	146.0	146.11	146.0	146.04	158676.0
2013-01-04 09:15:00	SPY	ETF	146.03	146.06	145.98	146.02	88162.0
2013-01-04 09:20:00	SPY	ETF	146.01	146.03	145.96	145.96	45251.0
2013-01-04 09:25:00	SPY	ETF	145.97	145.99	145.92	145.97	176280.0
2013-01-04 09:30:00	SPY	ETF	145.97	145.97	145.74	145.81	3069831.0
2013-01-04 09:35:00	SPY	ETF	145.81	145.84	145.67	145.71	2302924.0
2013-01-04 09:40:00	SPY	ETF	145.71	146.0	145.7	145.99	1687116.0
2013-01-04 09:45:00	SPY	ETF	145.99	146.02	145.94	146.0	1870594.0
2013-01-04 09:50:00	SPY	ETF	145.995	146.1	145.91	146.051	1507175.0
2013-01-04 09:55:00	SPY	ETF	146.05	146.16	146.02	146.13	987129.0
2013-01-04 10:00:00	SPY	ETF	146.15	146.21	145.83	145.93	3212988.0

> showing 50 of 41,467 rows — these rows as CSV

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