PREVIEW / stock_1hour / 2009-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-03.parquet
  size:    6 KB
  rows:    30
  symbols: 4

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
2009-07-03 09:00:00	C.C-DELISTED	Stock	0.1	0.1	0.1	0.1	80000.0
2009-07-03 09:00:00	C.K	Stock	21.86	22.1	21.86	22.05	75100.0
2009-07-03 09:00:00	C.K-DELISTED	Stock	21.86	22.1	21.86	22.05	75100.0
2009-07-03 09:00:00	C.L-DELISTED	Stock	35.0	35.0	34.8	34.97	9400.0
2009-07-03 10:00:00	C.C-DELISTED	Stock	0.11	0.11	0.11	0.11	2000.0
2009-07-03 10:00:00	C.K	Stock	22.05	22.16	21.85	21.88	85100.0
2009-07-03 10:00:00	C.K-DELISTED	Stock	22.05	22.16	21.85	21.88	85100.0
2009-07-03 10:00:00	C.L-DELISTED	Stock	34.96	35.0	34.82	34.83	16600.0
2009-07-03 10:00:00	C.PRP-DELISTED	Stock	0.12	0.12	0.12	0.12	1000.0
2009-07-03 11:00:00	C.K	Stock	21.89	21.95	21.85	21.85	32600.0
2009-07-03 11:00:00	C.K-DELISTED	Stock	21.89	21.95	21.85	21.85	32600.0
2009-07-03 11:00:00	C.L-DELISTED	Stock	34.83	34.87	34.67	34.69	11000.0
2009-07-03 12:00:00	C.K	Stock	21.86	21.86	21.72	21.73	48600.0
2009-07-03 12:00:00	C.K-DELISTED	Stock	21.86	21.86	21.72	21.73	48600.0
2009-07-03 12:00:00	C.L-DELISTED	Stock	34.69	34.7	34.43	34.56	9100.0
2009-07-03 12:00:00	C.PRP-DELISTED	Stock	0.115	0.115	0.115	0.115	27500.0
2009-07-03 13:00:00	C.K	Stock	21.73	21.9	21.72	21.83	41400.0
2009-07-03 13:00:00	C.K-DELISTED	Stock	21.73	21.9	21.72	21.83	41400.0
2009-07-03 13:00:00	C.L-DELISTED	Stock	34.49	34.79	34.49	34.66	8800.0
2009-07-03 14:00:00	C.K	Stock	21.79	21.86	21.73	21.82	23600.0
2009-07-03 14:00:00	C.K-DELISTED	Stock	21.79	21.86	21.73	21.82	23600.0
2009-07-03 14:00:00	C.L-DELISTED	Stock	34.65	34.73	34.62	34.63	7900.0
2009-07-03 14:00:00	C.PRP-DELISTED	Stock	0.12	0.12	0.12	0.12	500.0
2009-07-03 15:00:00	C.K	Stock	21.81	21.98	21.8	21.95	54300.0
2009-07-03 15:00:00	C.K-DELISTED	Stock	21.81	21.98	21.8	21.95	54300.0
2009-07-03 15:00:00	C.L-DELISTED	Stock	34.62	35.05	34.61	34.75	30500.0
2009-07-03 15:00:00	C.PRP-DELISTED	Stock	0.115	0.115	0.115	0.115	25000.0
2009-07-03 16:00:00	C.K	Stock	21.94	21.94	21.94	21.94	11400.0
2009-07-03 16:00:00	C.K-DELISTED	Stock	21.94	21.94	21.94	21.94	11400.0
2009-07-03 16:00:00	C.L-DELISTED	Stock	35.06	35.06	35.06	35.06	1500.0

> showing 30 of 30 rows — these rows as CSV

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