PREVIEW / stock_1hour / 2010-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-27.parquet
  size:    910 KB
  rows:    43,582
  symbols: 3,468

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-05-27 04:00:00	AAPL	Stock	8.8818	8.9071	8.825	8.9071	33600.0
2010-05-27 05:00:00	AAPL	Stock	8.9071	8.9111	8.9071	8.9111	8400.0
2010-05-27 06:00:00	AAPL	Stock	8.9143	8.9571	8.9143	8.9571	36400.0
2010-05-27 07:00:00	AAPL	Stock	8.9439	8.9629	8.9021	8.9186	1234184.0
2010-05-27 08:00:00	AAPL	Stock	8.9146	8.9286	8.8932	8.9107	5936140.0
2010-05-27 09:00:00	AAPL	Stock	8.9107	8.9821	8.8968	8.9336	119987196.0
2010-05-27 10:00:00	AAPL	Stock	8.9336	8.9682	8.9107	8.9357	117782560.0
2010-05-27 11:00:00	AAPL	Stock	8.9352	8.9679	8.9286	8.9604	76779360.0
2010-05-27 12:00:00	AAPL	Stock	8.9604	8.9629	8.9396	8.9521	50693272.0
2010-05-27 13:00:00	AAPL	Stock	8.9532	8.9907	8.9289	8.9707	71312612.0
2010-05-27 14:00:00	AAPL	Stock	8.9706	9.0064	8.9614	8.9848	69411216.0
2010-05-27 15:00:00	AAPL	Stock	8.9846	9.0675	8.9714	9.0532	117292840.0
2010-05-27 16:00:00	AAPL	Stock	9.0532	9.0661	8.9445	9.0625	25119864.0
2010-05-27 17:00:00	AAPL	Stock	9.0625	9.0911	8.9451	9.0911	3280284.0
2010-05-27 18:00:00	AAPL	Stock	9.0929	9.1589	9.0482	9.1246	3271716.0
2010-05-27 19:00:00	AAPL	Stock	9.1182	9.1429	9.1079	9.1429	809424.0
2010-05-27 04:00:00	MSFT	Stock	25.61	25.61	25.31	25.57	41319.0
2010-05-27 05:00:00	MSFT	Stock	25.59	25.6	25.59	25.6	2600.0
2010-05-27 06:00:00	MSFT	Stock	25.69	25.79	25.6	25.79	61069.0
2010-05-27 07:00:00	MSFT	Stock	25.8	25.8	25.7	25.76	116698.0
2010-05-27 08:00:00	MSFT	Stock	25.75	25.77	25.43	25.57	1478548.0
2010-05-27 09:00:00	MSFT	Stock	25.56	26.29	25.55	26.02	33626343.0
2010-05-27 10:00:00	MSFT	Stock	26.02	26.352	25.97	26.26	20005760.0
2010-05-27 11:00:00	MSFT	Stock	26.255	26.36	26.14	26.18	13093766.0
2010-05-27 12:00:00	MSFT	Stock	26.18	26.19	25.97	26.02	13196970.0
2010-05-27 13:00:00	MSFT	Stock	26.02	26.1	25.89	25.9	10395368.0
2010-05-27 14:00:00	MSFT	Stock	25.9	26.05	25.9	25.984	12810607.0
2010-05-27 15:00:00	MSFT	Stock	25.98	26.1	25.88	25.95	23640180.0
2010-05-27 16:00:00	MSFT	Stock	25.96	26.383	25.01	25.98	5149269.0
2010-05-27 17:00:00	MSFT	Stock	25.98	26.0	25.664	25.99	722940.0
2010-05-27 18:00:00	MSFT	Stock	25.96	26.03	25.96	26.0	72797.0
2010-05-27 19:00:00	MSFT	Stock	26.01	26.03	25.87	25.87	20563.0
2010-05-27 08:00:00	NVDA	Stock	0.327	0.33	0.3263	0.3278	1205760.0
2010-05-27 09:00:00	NVDA	Stock	0.3278	0.3325	0.3263	0.3298	97275400.0
2010-05-27 10:00:00	NVDA	Stock	0.3298	0.3315	0.326	0.3284	128194160.0
2010-05-27 11:00:00	NVDA	Stock	0.3283	0.3303	0.3278	0.3295	54303360.0
2010-05-27 12:00:00	NVDA	Stock	0.3293	0.3318	0.329	0.3315	54279840.0
2010-05-27 13:00:00	NVDA	Stock	0.3313	0.3342	0.3303	0.333	101961280.0
2010-05-27 14:00:00	NVDA	Stock	0.333	0.3355	0.3325	0.334	66487080.0
2010-05-27 15:00:00	NVDA	Stock	0.334	0.3375	0.3338	0.3375	182771360.0
2010-05-27 16:00:00	NVDA	Stock	0.3375	0.3375	0.3186	0.3375	21577320.0
2010-05-27 17:00:00	NVDA	Stock	0.3375	0.338	0.3334	0.3334	2179560.0
2010-05-27 18:00:00	NVDA	Stock	0.335	0.3368	0.3345	0.3368	30000.0
2010-05-27 06:00:00	AMZN	Stock	6.211	6.211	6.211	6.211	8000.0
2010-05-27 07:00:00	AMZN	Stock	6.275	6.2775	6.272	6.2725	19240.0
2010-05-27 08:00:00	AMZN	Stock	6.2725	6.275	6.225	6.2255	124660.0
2010-05-27 09:00:00	AMZN	Stock	6.23	6.2615	6.03	6.238	11841340.0
2010-05-27 10:00:00	AMZN	Stock	6.242	6.2965	6.2105	6.2325	16301720.0
2010-05-27 11:00:00	AMZN	Stock	6.2365	6.2575	6.221	6.2495	10051160.0
2010-05-27 12:00:00	AMZN	Stock	6.2484	6.26	6.2325	6.2415	9137120.0

> showing 50 of 43,582 rows — these rows as CSV

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