PREVIEW / stock_30min / 2008-12-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-12-29.parquet
  size:    1.2 MB
  rows:    69,679
  symbols: 3,370

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
2008-12-29 06:00:00	AAPL	Stock	3.1089	3.1089	3.1089	3.1089	4200.0
2008-12-29 06:30:00	AAPL	Stock	3.1179	3.1304	3.1179	3.1304	14000.0
2008-12-29 07:00:00	AAPL	Stock	3.1286	3.1286	3.1089	3.115	34300.0
2008-12-29 07:30:00	AAPL	Stock	3.1143	3.1143	3.1089	3.1139	48300.0
2008-12-29 08:00:00	AAPL	Stock	3.1071	3.1079	3.0911	3.0996	588756.0
2008-12-29 08:30:00	AAPL	Stock	3.1004	3.1071	3.0971	3.1036	639436.0
2008-12-29 09:00:00	AAPL	Stock	3.1043	3.1104	3.0896	3.0957	1015252.0
2008-12-29 09:30:00	AAPL	Stock	3.0964	3.1293	3.0879	3.1067	60195884.0
2008-12-29 10:00:00	AAPL	Stock	3.1064	3.1114	3.075	3.0821	50546608.0
2008-12-29 10:30:00	AAPL	Stock	3.0821	3.0896	3.0707	3.0839	42167188.0
2008-12-29 11:00:00	AAPL	Stock	3.0836	3.0893	3.0725	3.0878	31734976.0
2008-12-29 11:30:00	AAPL	Stock	3.0875	3.0886	3.075	3.08	25992456.0
2008-12-29 12:00:00	AAPL	Stock	3.08	3.0846	3.0664	3.0704	25026120.0
2008-12-29 12:30:00	AAPL	Stock	3.0704	3.0725	3.0518	3.0518	27398280.0
2008-12-29 13:00:00	AAPL	Stock	3.0521	3.0554	3.0382	3.051	35706552.0
2008-12-29 13:30:00	AAPL	Stock	3.0504	3.0671	3.05	3.0618	28783804.0
2008-12-29 14:00:00	AAPL	Stock	3.0625	3.0704	3.0518	3.0657	28136472.0
2008-12-29 14:30:00	AAPL	Stock	3.0657	3.0707	3.0586	3.0692	27803160.0
2008-12-29 15:00:00	AAPL	Stock	3.0693	3.0829	3.0675	3.075	53319252.0
2008-12-29 15:30:00	AAPL	Stock	3.0746	3.1046	3.0668	3.0929	103800200.0
2008-12-29 16:00:00	AAPL	Stock	3.0929	3.1004	3.0741	3.0982	126492408.0
2008-12-29 16:30:00	AAPL	Stock	3.1	3.1018	3.0932	3.0989	9323692.0
2008-12-29 17:00:00	AAPL	Stock	3.0989	3.0989	3.0971	3.0971	42280.0
2008-12-29 17:30:00	AAPL	Stock	3.0979	3.0982	3.0964	3.0964	70000.0
2008-12-29 18:00:00	AAPL	Stock	3.0968	3.0968	3.0932	3.0964	1753024.0
2008-12-29 18:30:00	AAPL	Stock	3.0946	3.0982	3.0939	3.0982	41020.0
2008-12-29 19:00:00	AAPL	Stock	3.1014	3.1014	3.0982	3.1014	11984.0
2008-12-29 19:30:00	AAPL	Stock	3.0939	3.1036	3.0939	3.1032	66920.0
2008-12-29 04:00:00	MSFT	Stock	19.19	19.27	19.19	19.27	700.0
2008-12-29 07:00:00	MSFT	Stock	19.27	19.27	19.27	19.27	100.0
2008-12-29 07:30:00	MSFT	Stock	19.31	19.41	19.3	19.41	1500.0
2008-12-29 08:00:00	MSFT	Stock	19.25	19.28	19.23	19.28	7500.0
2008-12-29 08:30:00	MSFT	Stock	19.28	19.28	19.23	19.27	9696.0
2008-12-29 09:00:00	MSFT	Stock	19.26	19.3	19.13	19.15	73463.0
2008-12-29 09:30:00	MSFT	Stock	19.16	19.21	19.04	19.07	2087046.0
2008-12-29 10:00:00	MSFT	Stock	19.07	19.07	18.88	18.91	3379518.0
2008-12-29 10:30:00	MSFT	Stock	18.91	18.95	18.83	18.84	2876787.0
2008-12-29 11:00:00	MSFT	Stock	18.84	18.86	18.76	18.79	3758934.0
2008-12-29 11:30:00	MSFT	Stock	18.79	18.81	18.75	18.77	2917716.0
2008-12-29 12:00:00	MSFT	Stock	18.77	18.82	18.76	18.76	3084591.0
2008-12-29 12:30:00	MSFT	Stock	18.76	18.78	18.7	18.7	1737974.0
2008-12-29 13:00:00	MSFT	Stock	18.7	18.73	18.64	18.661	2038189.0
2008-12-29 13:30:00	MSFT	Stock	18.665	18.83	18.66	18.8	2105142.0
2008-12-29 14:00:00	MSFT	Stock	18.792	18.82	18.7	18.756	2286220.0
2008-12-29 14:30:00	MSFT	Stock	18.76	18.83	18.7	18.8	2305436.0
2008-12-29 15:00:00	MSFT	Stock	18.8	18.86	18.77	18.81	3528089.0
2008-12-29 15:30:00	MSFT	Stock	18.81	18.98	18.8	18.97	10056629.0
2008-12-29 16:00:00	MSFT	Stock	18.98	19.134	18.65	18.959	8080620.0
2008-12-29 16:30:00	MSFT	Stock	19.02	19.02	18.96	18.98	7330655.0
2008-12-29 17:00:00	MSFT	Stock	18.97	18.98	18.94	18.94	10278.0

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

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