PREVIEW / stock_1hour / 2012-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-15.parquet
  size:    941 KB
  rows:    44,365
  symbols: 3,515

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
2012-03-15 04:00:00	AAPL	Stock	21.3036	21.3571	21.1857	21.2857	390124.0
2012-03-15 05:00:00	AAPL	Stock	21.2875	21.3168	21.2875	21.3	180180.0
2012-03-15 06:00:00	AAPL	Stock	21.2893	21.2964	21.2679	21.2929	123032.0
2012-03-15 07:00:00	AAPL	Stock	21.2929	21.3571	21.2714	21.2825	2982588.0
2012-03-15 08:00:00	AAPL	Stock	21.2768	21.4171	21.2732	21.3975	14759696.0
2012-03-15 09:00:00	AAPL	Stock	21.3929	21.4318	21.1964	21.2782	211282064.0
2012-03-15 10:00:00	AAPL	Stock	21.2791	21.3061	20.8596	21.1389	251340740.0
2012-03-15 11:00:00	AAPL	Stock	21.1357	21.2132	21.0114	21.1321	89221860.0
2012-03-15 12:00:00	AAPL	Stock	21.1332	21.1807	21.0575	21.0575	74254572.0
2012-03-15 13:00:00	AAPL	Stock	21.0574	21.1136	20.7579	20.8307	168241864.0
2012-03-15 14:00:00	AAPL	Stock	20.8304	21.0871	20.6625	20.9804	169695008.0
2012-03-15 15:00:00	AAPL	Stock	20.9853	21.0339	20.7989	20.9071	141250116.0
2012-03-15 16:00:00	AAPL	Stock	20.9075	21.1685	20.7661	20.8929	23528708.0
2012-03-15 17:00:00	AAPL	Stock	20.8982	20.9104	20.8754	20.8929	1043644.0
2012-03-15 18:00:00	AAPL	Stock	20.8964	20.9032	20.8839	20.8875	440944.0
2012-03-15 19:00:00	AAPL	Stock	20.8882	20.9243	20.8839	20.9036	673372.0
2012-03-15 04:00:00	MSFT	Stock	32.78	32.8	32.78	32.8	900.0
2012-03-15 05:00:00	MSFT	Stock	32.8	32.8	32.8	32.8	200.0
2012-03-15 06:00:00	MSFT	Stock	32.74	32.74	32.69	32.74	2700.0
2012-03-15 07:00:00	MSFT	Stock	32.77	32.8	32.77	32.8	1330.0
2012-03-15 08:00:00	MSFT	Stock	32.77	32.8	32.77	32.8	12696.0
2012-03-15 09:00:00	MSFT	Stock	32.81	32.84	32.58	32.81	4302265.0
2012-03-15 10:00:00	MSFT	Stock	32.8	32.94	32.77	32.85	6403238.0
2012-03-15 11:00:00	MSFT	Stock	32.857	32.9	32.81	32.88	3549023.0
2012-03-15 12:00:00	MSFT	Stock	32.89	32.94	32.85	32.869	3438915.0
2012-03-15 13:00:00	MSFT	Stock	32.87	32.89	32.79	32.83	8275529.0
2012-03-15 14:00:00	MSFT	Stock	32.82	32.88	32.78	32.805	6278172.0
2012-03-15 15:00:00	MSFT	Stock	32.8	32.86	32.78	32.85	10913490.0
2012-03-15 16:00:00	MSFT	Stock	32.84	32.91	32.748	32.83	5031211.0
2012-03-15 17:00:00	MSFT	Stock	32.85	32.85	32.8	32.8	1030.0
2012-03-15 18:00:00	MSFT	Stock	32.79	32.79	32.79	32.79	685.0
2012-03-15 19:00:00	MSFT	Stock	32.78	32.8	32.78	32.78	1870.0
2012-03-15 04:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	8000.0
2012-03-15 05:00:00	NVDA	Stock	0.3588	0.3588	0.3588	0.3588	4000.0
2012-03-15 07:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	4000.0
2012-03-15 08:00:00	NVDA	Stock	0.3612	0.362	0.3612	0.362	225960.0
2012-03-15 09:00:00	NVDA	Stock	0.362	0.3632	0.359	0.3622	34940680.0
2012-03-15 10:00:00	NVDA	Stock	0.3625	0.3665	0.3622	0.364	59761440.0
2012-03-15 11:00:00	NVDA	Stock	0.3638	0.3642	0.3625	0.3625	58250400.0
2012-03-15 12:00:00	NVDA	Stock	0.3625	0.364	0.3625	0.3631	33118400.0
2012-03-15 13:00:00	NVDA	Stock	0.3632	0.3638	0.3619	0.3629	44410080.0
2012-03-15 14:00:00	NVDA	Stock	0.363	0.3638	0.362	0.3632	42412520.0
2012-03-15 15:00:00	NVDA	Stock	0.3634	0.3652	0.3628	0.3642	85632440.0
2012-03-15 16:00:00	NVDA	Stock	0.3645	0.365	0.359	0.3645	19941240.0
2012-03-15 17:00:00	NVDA	Stock	0.3638	0.3638	0.3638	0.3638	4000.0
2012-03-15 19:00:00	NVDA	Stock	0.3632	0.3632	0.3632	0.3632	200000.0
2012-03-15 04:00:00	AMZN	Stock	9.0875	9.1015	9.0875	9.1015	22000.0
2012-03-15 08:00:00	AMZN	Stock	9.1135	9.1265	9.112	9.125	54000.0
2012-03-15 09:00:00	AMZN	Stock	9.129	9.1625	9.015	9.1325	13176660.0
2012-03-15 10:00:00	AMZN	Stock	9.131	9.1855	9.097	9.122	14218480.0

> showing 50 of 44,365 rows — these rows as CSV

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