PREVIEW / stock_30min / 2009-11-27

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-27.parquet
  size:    874 KB
  rows:    43,304
  symbols: 3,333

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-11-27 04:00:00	AAPL	Stock	7.0707	7.1161	7.0707	7.0718	42000.0
2009-11-27 04:30:00	AAPL	Stock	7.1025	7.1025	7.1025	7.1025	11200.0
2009-11-27 05:00:00	AAPL	Stock	7.0596	7.0596	7.0361	7.0361	102200.0
2009-11-27 05:30:00	AAPL	Stock	7.0336	7.0336	7.0336	7.0336	2800.0
2009-11-27 06:30:00	AAPL	Stock	7.0514	7.0775	7.0514	7.0732	138292.0
2009-11-27 07:00:00	AAPL	Stock	7.0736	7.1111	7.0736	7.0893	653660.0
2009-11-27 07:30:00	AAPL	Stock	7.0893	7.1154	7.0757	7.115	617820.0
2009-11-27 08:00:00	AAPL	Stock	7.115	7.1421	7.1089	7.1321	2558920.0
2009-11-27 08:30:00	AAPL	Stock	7.1286	7.1339	7.1036	7.1071	1716764.0
2009-11-27 09:00:00	AAPL	Stock	7.1071	7.1275	7.0982	7.1132	2567880.0
2009-11-27 09:30:00	AAPL	Stock	7.115	7.1696	7.0846	7.1582	86051280.0
2009-11-27 10:00:00	AAPL	Stock	7.1586	7.2011	7.1564	7.1846	44197832.0
2009-11-27 10:30:00	AAPL	Stock	7.1836	7.2411	7.1743	7.2243	35655480.0
2009-11-27 11:00:00	AAPL	Stock	7.2232	7.2486	7.2157	7.22	29558816.0
2009-11-27 11:30:00	AAPL	Stock	7.22	7.2257	7.2054	7.2236	17927000.0
2009-11-27 12:00:00	AAPL	Stock	7.2236	7.2279	7.1857	7.1964	20773256.0
2009-11-27 12:30:00	AAPL	Stock	7.197	7.2321	7.1643	7.1707	39972072.0
2009-11-27 13:00:00	AAPL	Stock	7.1654	7.1834	7.1554	7.165	9142056.0
2009-11-27 13:30:00	AAPL	Stock	7.1679	7.2277	7.1639	7.1732	127344.0
2009-11-27 14:00:00	AAPL	Stock	7.1711	7.1761	7.1696	7.1704	49728.0
2009-11-27 14:30:00	AAPL	Stock	7.1714	7.1714	7.1671	7.1696	134288.0
2009-11-27 15:00:00	AAPL	Stock	7.1671	7.1671	7.1639	7.1664	28000.0
2009-11-27 15:30:00	AAPL	Stock	7.1732	7.1732	7.1607	7.1614	98448.0
2009-11-27 16:00:00	AAPL	Stock	7.1768	7.1836	7.1675	7.1732	29120.0
2009-11-27 16:30:00	AAPL	Stock	7.1732	7.1768	7.1732	7.1732	44436.0
2009-11-27 04:00:00	MSFT	Stock	29.29	29.29	29.11	29.15	1000.0
2009-11-27 06:00:00	MSFT	Stock	29.15	29.18	29.1	29.1	1600.0
2009-11-27 06:30:00	MSFT	Stock	29.03	29.03	29.03	29.03	1000.0
2009-11-27 07:00:00	MSFT	Stock	29.11	29.11	29.05	29.05	5300.0
2009-11-27 07:30:00	MSFT	Stock	29.05	29.2	29.04	29.2	7831.0
2009-11-27 08:00:00	MSFT	Stock	29.2	29.39	29.13	29.38	28242.0
2009-11-27 08:30:00	MSFT	Stock	29.33	29.34	29.12	29.12	32514.0
2009-11-27 09:00:00	MSFT	Stock	29.11	29.19	29.05	29.1	177448.0
2009-11-27 09:30:00	MSFT	Stock	29.11	29.35	28.75	29.1	6766751.0
2009-11-27 10:00:00	MSFT	Stock	29.1	29.29	29.1	29.15	4510905.0
2009-11-27 10:30:00	MSFT	Stock	29.16	29.29	29.12	29.183	3311767.0
2009-11-27 11:00:00	MSFT	Stock	29.204	29.29	29.17	29.2	2885119.0
2009-11-27 11:30:00	MSFT	Stock	29.2	29.27	29.15	29.27	2028076.0
2009-11-27 12:00:00	MSFT	Stock	29.27	29.29	29.18	29.22	2041086.0
2009-11-27 12:30:00	MSFT	Stock	29.213	29.39	29.21	29.24	3989655.0
2009-11-27 13:00:00	MSFT	Stock	29.23	29.31	29.192	29.31	1746594.0
2009-11-27 13:30:00	MSFT	Stock	29.22	29.23	29.22	29.23	2014.0
2009-11-27 14:00:00	MSFT	Stock	29.38	29.38	29.22	29.22	9631.0
2009-11-27 14:30:00	MSFT	Stock	29.22	29.22	29.22	29.22	1600.0
2009-11-27 15:00:00	MSFT	Stock	29.22	29.22	29.2	29.2	1973.0
2009-11-27 15:30:00	MSFT	Stock	29.2	29.2	29.2	29.2	2000.0
2009-11-27 16:30:00	MSFT	Stock	29.19	29.19	29.19	29.19	150.0
2009-11-27 07:00:00	NVDA	Stock	0.315	0.315	0.315	0.315	4000.0
2009-11-27 08:00:00	NVDA	Stock	0.317	0.3188	0.315	0.3185	158200.0
2009-11-27 08:30:00	NVDA	Stock	0.3188	0.3188	0.3163	0.3188	141600.0

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

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