PREVIEW / etf_5min / 2010-11-29

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-11-29.parquet
  size:    846 KB
  rows:    35,050

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-11-29 04:00:00	SPY	ETF	119.55	119.72	119.55	119.66	2175.0
2010-11-29 04:05:00	SPY	ETF	119.71	119.71	119.71	119.71	100.0
2010-11-29 04:15:00	SPY	ETF	119.61	119.61	119.61	119.61	200.0
2010-11-29 04:20:00	SPY	ETF	119.67	119.75	119.63	119.75	13750.0
2010-11-29 04:25:00	SPY	ETF	119.75	119.78	119.73	119.78	9900.0
2010-11-29 04:30:00	SPY	ETF	119.74	119.74	119.74	119.74	500.0
2010-11-29 04:35:00	SPY	ETF	119.76	119.76	119.69	119.7	8900.0
2010-11-29 04:40:00	SPY	ETF	119.52	119.52	119.35	119.44	1200.0
2010-11-29 04:45:00	SPY	ETF	119.3	119.44	119.3	119.44	4800.0
2010-11-29 04:50:00	SPY	ETF	119.43	119.53	119.43	119.48	1100.0
2010-11-29 04:55:00	SPY	ETF	119.41	119.46	119.41	119.46	800.0
2010-11-29 05:00:00	SPY	ETF	119.35	119.35	119.25	119.25	600.0
2010-11-29 05:05:00	SPY	ETF	119.25	119.25	119.1	119.1	1600.0
2010-11-29 05:10:00	SPY	ETF	119.05	119.19	119.0	119.19	800.0
2010-11-29 05:15:00	SPY	ETF	119.15	119.26	119.15	119.26	900.0
2010-11-29 05:35:00	SPY	ETF	119.14	119.21	119.14	119.17	2400.0
2010-11-29 05:40:00	SPY	ETF	119.12	119.12	119.01	119.01	300.0
2010-11-29 05:45:00	SPY	ETF	118.91	118.91	118.91	118.91	500.0
2010-11-29 05:50:00	SPY	ETF	118.97	118.98	118.97	118.98	300.0
2010-11-29 05:55:00	SPY	ETF	119.02	119.08	119.02	119.07	800.0
2010-11-29 06:15:00	SPY	ETF	119.03	119.03	119.03	119.03	900.0
2010-11-29 06:20:00	SPY	ETF	119.02	119.02	118.98	118.98	7400.0
2010-11-29 06:25:00	SPY	ETF	118.89	118.89	118.88	118.88	5000.0
2010-11-29 06:30:00	SPY	ETF	119.0	119.05	119.0	119.05	400.0
2010-11-29 06:35:00	SPY	ETF	119.1	119.12	119.1	119.12	1600.0
2010-11-29 06:45:00	SPY	ETF	119.13	119.19	119.13	119.19	12400.0
2010-11-29 06:50:00	SPY	ETF	119.25	119.27	119.25	119.25	73900.0
2010-11-29 06:55:00	SPY	ETF	119.25	119.3	119.17	119.21	37700.0
2010-11-29 07:00:00	SPY	ETF	119.22	119.24	119.1	119.1	32000.0
2010-11-29 07:05:00	SPY	ETF	119.14	119.15	119.05	119.09	51200.0
2010-11-29 07:10:00	SPY	ETF	119.07	119.11	118.93	118.96	51500.0
2010-11-29 07:15:00	SPY	ETF	118.96	119.01	118.96	118.98	15600.0
2010-11-29 07:20:00	SPY	ETF	118.96	119.01	118.82	118.86	23400.0
2010-11-29 07:25:00	SPY	ETF	118.89	118.92	118.8	118.87	118650.0
2010-11-29 07:30:00	SPY	ETF	118.85	118.85	118.57	118.7	200105.0
2010-11-29 07:35:00	SPY	ETF	118.68	118.68	118.48	118.63	260553.0
2010-11-29 07:40:00	SPY	ETF	118.66	118.68	118.61	118.63	38718.0
2010-11-29 07:45:00	SPY	ETF	118.65	118.68	118.6	118.66	41400.0
2010-11-29 07:50:00	SPY	ETF	118.66	118.8	118.64	118.78	25300.0
2010-11-29 07:55:00	SPY	ETF	118.75	118.78	118.7	118.71	51450.0
2010-11-29 08:00:00	SPY	ETF	118.72	119.68	118.7	118.75	114800.0
2010-11-29 08:05:00	SPY	ETF	118.57	119.385	118.57	118.73	704120.0
2010-11-29 08:10:00	SPY	ETF	118.73	118.75	118.59	118.61	279462.0
2010-11-29 08:15:00	SPY	ETF	118.62	118.7	118.6	118.67	67513.0
2010-11-29 08:20:00	SPY	ETF	118.69	118.83	118.67	118.79	72501.0
2010-11-29 08:25:00	SPY	ETF	118.77	118.82	118.77	118.82	78977.0
2010-11-29 08:30:00	SPY	ETF	118.8	118.83	118.75	118.78	474128.0
2010-11-29 08:35:00	SPY	ETF	118.8	118.84	118.77	118.79	184612.0
2010-11-29 08:40:00	SPY	ETF	118.78	118.79	118.7	118.7	122128.0
2010-11-29 08:45:00	SPY	ETF	118.71	118.75	118.7	118.74	253963.0

> showing 50 of 35,050 rows — these rows as CSV

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