PREVIEW / stock_1hour / 2001-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-02-07.parquet
  size:    356 KB
  rows:    16,480
  symbols: 1,263

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
2001-02-07 08:00:00	AAPL	Stock	0.3672	0.3728	0.3672	0.3705	128800.0
2001-02-07 09:00:00	AAPL	Stock	0.3717	0.3783	0.3672	0.3683	42364000.0
2001-02-07 10:00:00	AAPL	Stock	0.3683	0.3705	0.3583	0.3616	45248000.0
2001-02-07 11:00:00	AAPL	Stock	0.3627	0.3638	0.3549	0.3594	69434400.0
2001-02-07 12:00:00	AAPL	Stock	0.3594	0.3605	0.3538	0.356	35761600.0
2001-02-07 13:00:00	AAPL	Stock	0.356	0.3583	0.3538	0.3549	20753600.0
2001-02-07 14:00:00	AAPL	Stock	0.3555	0.365	0.3538	0.3605	38494400.0
2001-02-07 15:00:00	AAPL	Stock	0.3605	0.3705	0.3594	0.3694	102009600.0
2001-02-07 16:00:00	AAPL	Stock	0.3705	0.3728	0.3538	0.3705	35324800.0
2001-02-07 17:00:00	AAPL	Stock	0.3705	0.3705	0.3683	0.3683	2212000.0
2001-02-07 18:00:00	AAPL	Stock	0.3694	0.3694	0.3672	0.3672	22400.0
2001-02-07 08:00:00	MSFT	Stock	30.5	31.0	30.5	30.875	222600.0
2001-02-07 09:00:00	MSFT	Stock	30.9062	31.8125	30.7188	31.7188	13195200.0
2001-02-07 10:00:00	MSFT	Stock	31.7188	32.0156	31.4062	31.4688	17720600.0
2001-02-07 11:00:00	MSFT	Stock	31.4688	31.8125	31.4688	31.6875	8534600.0
2001-02-07 12:00:00	MSFT	Stock	31.6875	31.75	31.4062	31.7188	7483200.0
2001-02-07 13:00:00	MSFT	Stock	31.6875	31.8438	31.4375	31.4688	7757400.0
2001-02-07 14:00:00	MSFT	Stock	31.4688	32.4062	31.4688	32.1875	27097400.0
2001-02-07 15:00:00	MSFT	Stock	32.2188	32.5312	32.0938	32.3438	39540800.0
2001-02-07 16:00:00	MSFT	Stock	32.3125	32.5	31.6719	32.2969	2329800.0
2001-02-07 17:00:00	MSFT	Stock	32.3438	32.5	31.9531	32.4062	24600.0
2001-02-07 18:00:00	MSFT	Stock	32.4062	32.4375	32.375	32.4375	7600.0
2001-02-07 09:00:00	NVDA	Stock	0.1948	0.1964	0.1901	0.1917	38496000.0
2001-02-07 10:00:00	NVDA	Stock	0.1914	0.1943	0.1802	0.1813	151824000.0
2001-02-07 11:00:00	NVDA	Stock	0.1813	0.1841	0.1799	0.1807	81456000.0
2001-02-07 12:00:00	NVDA	Stock	0.1813	0.182	0.1771	0.1792	70008000.0
2001-02-07 13:00:00	NVDA	Stock	0.1789	0.1792	0.1766	0.1779	72984000.0
2001-02-07 14:00:00	NVDA	Stock	0.1776	0.1789	0.1766	0.1784	82272000.0
2001-02-07 15:00:00	NVDA	Stock	0.1776	0.1891	0.1776	0.187	196872000.0
2001-02-07 16:00:00	NVDA	Stock	0.187	0.1906	0.1865	0.187	16392000.0
2001-02-07 17:00:00	NVDA	Stock	0.188	0.188	0.188	0.188	24000.0
2001-02-07 08:00:00	AMZN	Stock	0.7688	0.7688	0.75	0.7688	490000.0
2001-02-07 09:00:00	AMZN	Stock	0.7688	0.7906	0.7563	0.7594	20196000.0
2001-02-07 10:00:00	AMZN	Stock	0.7594	0.7688	0.7281	0.7375	30000000.0
2001-02-07 11:00:00	AMZN	Stock	0.7406	0.775	0.7406	0.7656	29394000.0
2001-02-07 12:00:00	AMZN	Stock	0.7656	0.7781	0.7438	0.7531	18888000.0
2001-02-07 13:00:00	AMZN	Stock	0.75	0.7594	0.7406	0.7531	13208000.0
2001-02-07 14:00:00	AMZN	Stock	0.7531	0.7563	0.7469	0.7531	9278000.0
2001-02-07 15:00:00	AMZN	Stock	0.7531	0.7688	0.75	0.75	21764000.0
2001-02-07 16:00:00	AMZN	Stock	0.75	0.7625	0.75	0.7625	5338000.0
2001-02-07 17:00:00	AMZN	Stock	0.7625	0.7625	0.7375	0.7375	166000.0
2001-02-07 18:00:00	AMZN	Stock	0.7531	0.7531	0.75	0.75	74000.0
2001-02-07 09:00:00	CL	Stock	29.0	29.13	28.74	28.815	1955800.0
2001-02-07 10:00:00	CL	Stock	28.815	29.175	28.815	29.17	1837600.0
2001-02-07 11:00:00	CL	Stock	29.175	29.36	29.175	29.345	1460600.0
2001-02-07 12:00:00	CL	Stock	29.34	29.475	29.33	29.425	1184200.0
2001-02-07 13:00:00	CL	Stock	29.425	29.625	29.425	29.605	1188800.0
2001-02-07 14:00:00	CL	Stock	29.6	29.675	29.51	29.62	789400.0
2001-02-07 15:00:00	CL	Stock	29.65	29.7	29.525	29.625	1350400.0
2001-02-07 16:00:00	CL	Stock	29.625	29.675	29.295	29.295	580800.0

> showing 50 of 16,480 rows — these rows as CSV

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