PREVIEW / etf_5min / 2010-11-03

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-11-03.parquet
  size:    828 KB
  rows:    34,638

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-03 04:00:00	SPY	ETF	119.76	119.76	119.76	119.76	300.0
2010-11-03 04:05:00	SPY	ETF	119.71	119.71	119.71	119.71	3500.0
2010-11-03 04:10:00	SPY	ETF	119.7	119.7	119.66	119.66	5100.0
2010-11-03 04:15:00	SPY	ETF	119.61	119.62	119.61	119.62	1400.0
2010-11-03 04:20:00	SPY	ETF	119.63	119.63	119.6	119.6	600.0
2010-11-03 04:25:00	SPY	ETF	119.66	119.7	119.66	119.7	350.0
2010-11-03 04:35:00	SPY	ETF	119.61	119.61	119.61	119.61	100.0
2010-11-03 04:40:00	SPY	ETF	119.61	119.61	119.59	119.59	5200.0
2010-11-03 04:50:00	SPY	ETF	119.64	119.64	119.64	119.64	2200.0
2010-11-03 05:10:00	SPY	ETF	119.7	119.75	119.7	119.75	200.0
2010-11-03 05:55:00	SPY	ETF	119.85	119.85	119.85	119.85	100.0
2010-11-03 06:00:00	SPY	ETF	119.84	119.84	119.84	119.84	200.0
2010-11-03 06:05:00	SPY	ETF	119.85	119.85	119.85	119.85	500.0
2010-11-03 06:10:00	SPY	ETF	119.88	119.89	119.88	119.89	700.0
2010-11-03 06:15:00	SPY	ETF	119.85	119.85	119.85	119.85	100.0
2010-11-03 06:40:00	SPY	ETF	119.83	119.83	119.83	119.83	500.0
2010-11-03 06:50:00	SPY	ETF	119.85	119.87	119.85	119.87	21400.0
2010-11-03 07:00:00	SPY	ETF	119.8	119.82	119.78	119.79	8780.0
2010-11-03 07:05:00	SPY	ETF	119.76	119.77	119.76	119.77	40600.0
2010-11-03 07:10:00	SPY	ETF	119.79	119.84	119.79	119.8	6600.0
2010-11-03 07:15:00	SPY	ETF	119.82	119.82	119.77	119.77	2900.0
2010-11-03 07:20:00	SPY	ETF	119.82	119.82	119.82	119.82	1000.0
2010-11-03 07:25:00	SPY	ETF	119.81	119.82	119.8	119.81	85000.0
2010-11-03 07:30:00	SPY	ETF	119.82	119.83	119.78	119.81	46800.0
2010-11-03 07:35:00	SPY	ETF	119.81	119.82	119.8	119.8	20980.0
2010-11-03 07:40:00	SPY	ETF	119.8	119.84	119.8	119.84	15500.0
2010-11-03 07:45:00	SPY	ETF	119.84	119.86	119.84	119.85	7020.0
2010-11-03 07:50:00	SPY	ETF	119.83	119.89	119.83	119.88	49435.0
2010-11-03 07:55:00	SPY	ETF	119.89	119.91	119.88	119.91	6300.0
2010-11-03 08:00:00	SPY	ETF	119.89	119.91	119.81	119.83	506109.0
2010-11-03 08:05:00	SPY	ETF	119.83	119.85	119.81	119.83	10880.0
2010-11-03 08:10:00	SPY	ETF	119.83	119.95	119.81	119.95	102052.0
2010-11-03 08:15:00	SPY	ETF	119.95	119.95	119.84	119.86	111521.0
2010-11-03 08:20:00	SPY	ETF	119.89	119.91	119.85	119.86	109462.0
2010-11-03 08:25:00	SPY	ETF	119.87	119.94	119.87	119.89	47357.0
2010-11-03 08:30:00	SPY	ETF	119.91	119.94	119.89	119.92	57646.0
2010-11-03 08:35:00	SPY	ETF	119.93	119.94	119.79	119.84	107782.0
2010-11-03 08:40:00	SPY	ETF	119.85	119.93	119.81	119.91	82725.0
2010-11-03 08:45:00	SPY	ETF	119.91	119.92	119.88	119.89	63599.0
2010-11-03 08:50:00	SPY	ETF	119.88	119.91	119.88	119.9	24691.0
2010-11-03 08:55:00	SPY	ETF	119.9	119.91	119.88	119.88	22343.0
2010-11-03 09:00:00	SPY	ETF	119.88	119.89	119.85	119.86	37634.0
2010-11-03 09:05:00	SPY	ETF	119.86	119.87	119.82	119.82	16113.0
2010-11-03 09:10:00	SPY	ETF	119.84	119.84	119.73	119.74	415548.0
2010-11-03 09:15:00	SPY	ETF	119.73	119.75	119.69	119.71	113738.0
2010-11-03 09:20:00	SPY	ETF	119.71	119.72	119.63	119.63	188424.0
2010-11-03 09:25:00	SPY	ETF	119.64	119.69	119.64	119.68	125487.0
2010-11-03 09:30:00	SPY	ETF	119.675	119.71	119.59	119.695	3152719.0
2010-11-03 09:35:00	SPY	ETF	119.69	119.76	119.58	119.64	2181854.0
2010-11-03 09:40:00	SPY	ETF	119.65	119.715	119.51	119.57	2975655.0

> showing 50 of 34,638 rows — these rows as CSV

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