PREVIEW / stock_1hour / 2010-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-18.parquet
  size:    6 KB
  rows:    44
  symbols: 6

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-01-18 09:00:00	C.C-DELISTED	Stock	0.075	0.075	0.075	0.075	22000.0
2010-01-18 09:00:00	C.K	Stock	19.89	20.04	19.89	20.02	143800.0
2010-01-18 09:00:00	C.K-DELISTED	Stock	19.89	20.04	19.89	20.02	143800.0
2010-01-18 09:00:00	C.L-DELISTED	Stock	34.35	34.35	34.25	34.25	6300.0
2010-01-18 09:00:00	C.PRC-DELISTED	Stock	0.46	0.46	0.43	0.43	23000.0
2010-01-18 09:00:00	C.PRK-DELISTED	Stock	5.0	5.0	5.0	5.0	2000.0
2010-01-18 09:00:00	C.PRP-DELISTED	Stock	0.175	0.18	0.175	0.18	16500.0
2010-01-18 10:00:00	C.C-DELISTED	Stock	0.075	0.075	0.075	0.075	5000.0
2010-01-18 10:00:00	C.K	Stock	20.01	20.01	19.97	19.98	71000.0
2010-01-18 10:00:00	C.K-DELISTED	Stock	20.01	20.01	19.97	19.98	71000.0
2010-01-18 10:00:00	C.L-DELISTED	Stock	34.23	34.27	34.19	34.25	15000.0
2010-01-18 10:00:00	C.PRC-DELISTED	Stock	0.44	0.45	0.425	0.425	30000.0
2010-01-18 10:00:00	C.PRP-DELISTED	Stock	0.18	0.185	0.18	0.18	100500.0
2010-01-18 11:00:00	C.K	Stock	19.98	19.98	19.85	19.88	122900.0
2010-01-18 11:00:00	C.K-DELISTED	Stock	19.98	19.98	19.85	19.88	122900.0
2010-01-18 11:00:00	C.L-DELISTED	Stock	34.26	34.49	34.23	34.43	24200.0
2010-01-18 11:00:00	C.PRC-DELISTED	Stock	0.44	0.44	0.44	0.44	1500.0
2010-01-18 11:00:00	C.PRP-DELISTED	Stock	0.18	0.18	0.18	0.18	7000.0
2010-01-18 12:00:00	C.C-DELISTED	Stock	0.07	0.07	0.07	0.07	4000.0
2010-01-18 12:00:00	C.K	Stock	19.87	19.88	19.81	19.85	69200.0
2010-01-18 12:00:00	C.K-DELISTED	Stock	19.87	19.88	19.81	19.85	69200.0
2010-01-18 12:00:00	C.L-DELISTED	Stock	34.44	34.71	34.43	34.6	36600.0
2010-01-18 12:00:00	C.PRC-DELISTED	Stock	0.45	0.455	0.45	0.455	37000.0
2010-01-18 12:00:00	C.PRP-DELISTED	Stock	0.175	0.175	0.175	0.175	12500.0
2010-01-18 13:00:00	C.C-DELISTED	Stock	0.07	0.07	0.07	0.07	5000.0
2010-01-18 13:00:00	C.K	Stock	19.82	19.86	19.75	19.77	117400.0
2010-01-18 13:00:00	C.K-DELISTED	Stock	19.82	19.86	19.75	19.77	117400.0
2010-01-18 13:00:00	C.L-DELISTED	Stock	34.59	34.85	34.59	34.66	62900.0
2010-01-18 13:00:00	C.PRC-DELISTED	Stock	0.46	0.46	0.455	0.455	6500.0
2010-01-18 13:00:00	C.PRK-DELISTED	Stock	5.03	5.03	5.03	5.03	1000.0
2010-01-18 13:00:00	C.PRP-DELISTED	Stock	0.175	0.18	0.175	0.18	20000.0
2010-01-18 14:00:00	C.K	Stock	19.76	19.78	19.72	19.73	68500.0
2010-01-18 14:00:00	C.K-DELISTED	Stock	19.76	19.78	19.72	19.73	68500.0
2010-01-18 14:00:00	C.L-DELISTED	Stock	34.73	34.77	34.65	34.76	49100.0
2010-01-18 14:00:00	C.PRC-DELISTED	Stock	0.455	0.46	0.455	0.46	3000.0
2010-01-18 14:00:00	C.PRP-DELISTED	Stock	0.165	0.165	0.165	0.165	14500.0
2010-01-18 15:00:00	C.K	Stock	19.72	19.78	19.66	19.71	223800.0
2010-01-18 15:00:00	C.K-DELISTED	Stock	19.72	19.78	19.66	19.71	223800.0
2010-01-18 15:00:00	C.L-DELISTED	Stock	34.76	35.0	34.76	34.93	109800.0
2010-01-18 15:00:00	C.PRC-DELISTED	Stock	0.46	0.465	0.46	0.465	38500.0
2010-01-18 15:00:00	C.PRP-DELISTED	Stock	0.17	0.175	0.17	0.175	15000.0
2010-01-18 16:00:00	C.K	Stock	19.72	19.72	19.72	19.72	77600.0
2010-01-18 16:00:00	C.K-DELISTED	Stock	19.72	19.72	19.72	19.72	77600.0
2010-01-18 16:00:00	C.L-DELISTED	Stock	34.89	34.89	34.89	34.89	3800.0

> showing 44 of 44 rows — these rows as CSV

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