PREVIEW / stock_30min / 2009-07-17

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-17.parquet
  size:    1.3 MB
  rows:    69,150
  symbols: 3,337

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-17 05:00:00	AAPL	Stock	5.2686	5.2686	5.2686	5.2686	2800.0
2009-07-17 06:30:00	AAPL	Stock	5.2664	5.2664	5.2664	5.2664	5600.0
2009-07-17 07:00:00	AAPL	Stock	5.2575	5.2714	5.2539	5.2571	83496.0
2009-07-17 07:30:00	AAPL	Stock	5.2536	5.2589	5.2504	5.2525	147280.0
2009-07-17 08:00:00	AAPL	Stock	5.2571	5.2804	5.2511	5.27	439264.0
2009-07-17 08:30:00	AAPL	Stock	5.2743	5.3193	5.2736	5.3107	879452.0
2009-07-17 09:00:00	AAPL	Stock	5.3107	5.3332	5.3014	5.325	2556932.0
2009-07-17 09:30:00	AAPL	Stock	5.3243	5.35	5.3082	5.3414	120417472.0
2009-07-17 10:00:00	AAPL	Stock	5.3414	5.3711	5.3289	5.3707	74587044.0
2009-07-17 10:30:00	AAPL	Stock	5.3711	5.3732	5.3543	5.3576	44924068.0
2009-07-17 11:00:00	AAPL	Stock	5.3576	5.3661	5.3554	5.3629	22428196.0
2009-07-17 11:30:00	AAPL	Stock	5.3625	5.3643	5.35	5.3604	21814044.0
2009-07-17 12:00:00	AAPL	Stock	5.3596	5.3693	5.3589	5.3641	19820332.0
2009-07-17 12:30:00	AAPL	Stock	5.3632	5.3711	5.3618	5.3679	17419724.0
2009-07-17 13:00:00	AAPL	Stock	5.3678	5.3889	5.3668	5.3886	30067884.0
2009-07-17 13:30:00	AAPL	Stock	5.3886	5.4068	5.3882	5.4014	38020052.0
2009-07-17 14:00:00	AAPL	Stock	5.4018	5.4172	5.4004	5.4036	40129012.0
2009-07-17 14:30:00	AAPL	Stock	5.4043	5.4096	5.3943	5.4057	27713252.0
2009-07-17 15:00:00	AAPL	Stock	5.4064	5.4118	5.3554	5.4029	31026044.0
2009-07-17 15:30:00	AAPL	Stock	5.4025	5.4293	5.3925	5.4196	95485516.0
2009-07-17 16:00:00	AAPL	Stock	5.4186	5.4204	5.409	5.4179	7468048.0
2009-07-17 16:30:00	AAPL	Stock	5.4179	5.4214	5.3789	5.4196	1599052.0
2009-07-17 17:00:00	AAPL	Stock	5.4193	5.4214	5.4089	5.4096	376488.0
2009-07-17 17:30:00	AAPL	Stock	5.4107	5.4175	5.4	5.41	336364.0
2009-07-17 18:00:00	AAPL	Stock	5.4093	5.4107	5.4068	5.4068	67480.0
2009-07-17 18:30:00	AAPL	Stock	5.4107	5.4118	5.4079	5.4079	48916.0
2009-07-17 19:00:00	AAPL	Stock	5.4089	5.415	5.4089	5.4132	20692.0
2009-07-17 19:30:00	AAPL	Stock	5.4164	5.4179	5.4107	5.4107	113652.0
2009-07-17 20:00:00	AAPL	Stock	5.3554	5.3554	5.3554	5.3554	333200.0
2009-07-17 07:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	100.0
2009-07-17 07:30:00	MSFT	Stock	24.24	24.24	24.08	24.14	8090.0
2009-07-17 08:00:00	MSFT	Stock	24.14	24.22	24.08	24.15	27045.0
2009-07-17 08:30:00	MSFT	Stock	24.16	24.2	24.16	24.2	1535.0
2009-07-17 09:00:00	MSFT	Stock	24.25	24.45	24.25	24.4	25850.0
2009-07-17 09:30:00	MSFT	Stock	24.39	24.45	24.13	24.285	11697058.0
2009-07-17 10:00:00	MSFT	Stock	24.28	24.33	24.25	24.33	3639891.0
2009-07-17 10:30:00	MSFT	Stock	24.33	24.35	24.13	24.135	4637707.0
2009-07-17 11:00:00	MSFT	Stock	24.13	24.21	24.11	24.2	2631956.0
2009-07-17 11:30:00	MSFT	Stock	24.21	24.21	24.12	24.142	1458105.0
2009-07-17 12:00:00	MSFT	Stock	24.15	24.236	24.14	24.18	1954114.0
2009-07-17 12:30:00	MSFT	Stock	24.18	24.26	24.18	24.19	2498434.0
2009-07-17 13:00:00	MSFT	Stock	24.2	24.28	24.19	24.24	2011439.0
2009-07-17 13:30:00	MSFT	Stock	24.25	24.3	24.23	24.25	3058007.0
2009-07-17 14:00:00	MSFT	Stock	24.252	24.28	24.23	24.28	1632246.0
2009-07-17 14:30:00	MSFT	Stock	24.28	24.28	24.19	24.24	2591033.0
2009-07-17 15:00:00	MSFT	Stock	24.25	24.26	24.2	24.2	1997275.0
2009-07-17 15:30:00	MSFT	Stock	24.207	24.29	24.1	24.29	9503207.0
2009-07-17 16:00:00	MSFT	Stock	24.28	24.291	23.91	24.26	1834505.0
2009-07-17 16:30:00	MSFT	Stock	24.29	24.29	24.16	24.29	700778.0
2009-07-17 17:00:00	MSFT	Stock	24.19	24.28	24.19	24.25	6100.0

> showing 50 of 69,150 rows — these rows as CSV

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