PREVIEW / stock_30min / 2010-05-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-14.parquet
  size:    1.4 MB
  rows:    76,091
  symbols: 3,488

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-14 04:00:00	AAPL	Stock	9.1857	9.1857	9.1829	9.1829	5600.0
2010-05-14 04:30:00	AAPL	Stock	9.1786	9.1786	9.1786	9.1786	2800.0
2010-05-14 05:00:00	AAPL	Stock	9.1532	9.1532	9.1429	9.1429	6104.0
2010-05-14 05:30:00	AAPL	Stock	9.1179	9.1179	9.0957	9.0961	51660.0
2010-05-14 06:00:00	AAPL	Stock	9.0964	9.1071	9.0893	9.1071	43400.0
2010-05-14 06:30:00	AAPL	Stock	9.1075	9.1246	9.1071	9.1161	40460.0
2010-05-14 07:00:00	AAPL	Stock	9.125	9.1679	9.125	9.1421	332444.0
2010-05-14 07:30:00	AAPL	Stock	9.1425	9.1786	9.1161	9.1721	836080.0
2010-05-14 08:00:00	AAPL	Stock	9.1718	9.1786	9.1321	9.15	2350376.0
2010-05-14 08:30:00	AAPL	Stock	9.1489	9.1607	9.1268	9.1491	1849568.0
2010-05-14 09:00:00	AAPL	Stock	9.1479	9.15	9.1118	9.1143	2939748.0
2010-05-14 09:30:00	AAPL	Stock	9.1143	9.16	9.0196	9.0389	117820556.0
2010-05-14 10:00:00	AAPL	Stock	9.04	9.0786	9.0093	9.0543	76757660.0
2010-05-14 10:30:00	AAPL	Stock	9.0536	9.075	9.0307	9.05	32334316.0
2010-05-14 11:00:00	AAPL	Stock	9.0507	9.0521	8.9554	8.9931	72555700.0
2010-05-14 11:30:00	AAPL	Stock	8.9936	9.0229	8.9554	8.9766	46090604.0
2010-05-14 12:00:00	AAPL	Stock	8.9771	8.9929	8.9107	8.9568	64156120.0
2010-05-14 12:30:00	AAPL	Stock	8.9568	9.0243	8.9468	9.0214	41183492.0
2010-05-14 13:00:00	AAPL	Stock	9.0229	9.041	8.995	9.0089	35362964.0
2010-05-14 13:30:00	AAPL	Stock	9.0089	9.0137	8.9521	8.9602	40179972.0
2010-05-14 14:00:00	AAPL	Stock	8.9607	8.9857	8.9464	8.9714	31883152.0
2010-05-14 14:30:00	AAPL	Stock	8.9714	9.0307	8.9711	8.9925	38611888.0
2010-05-14 15:00:00	AAPL	Stock	8.9907	9.0054	8.95	8.9718	36693692.0
2010-05-14 15:30:00	AAPL	Stock	8.9721	9.1004	8.9714	9.0714	84931532.0
2010-05-14 16:00:00	AAPL	Stock	9.0664	9.2271	9.0064	9.09	19161464.0
2010-05-14 16:30:00	AAPL	Stock	9.0879	9.1036	8.9846	9.0896	1536808.0
2010-05-14 17:00:00	AAPL	Stock	9.0982	9.1	9.0829	9.0843	608552.0
2010-05-14 17:30:00	AAPL	Stock	9.085	9.0882	9.0804	9.0864	135660.0
2010-05-14 18:00:00	AAPL	Stock	9.0875	9.0961	9.065	9.0875	505092.0
2010-05-14 18:30:00	AAPL	Stock	9.0911	9.0911	9.0714	9.075	235116.0
2010-05-14 19:00:00	AAPL	Stock	9.075	9.0804	9.075	9.0761	99820.0
2010-05-14 19:30:00	AAPL	Stock	9.0768	9.0893	9.0754	9.0786	241276.0
2010-05-14 20:00:00	AAPL	Stock	8.9982	8.9982	8.9982	8.9982	602000.0
2010-05-14 08:00:00	MSFT	Stock	29.18	29.18	29.02	29.16	1141.0
2010-05-14 08:30:00	MSFT	Stock	29.07	29.11	29.03	29.11	8700.0
2010-05-14 09:00:00	MSFT	Stock	29.11	29.21	29.06	29.2	28441.0
2010-05-14 09:30:00	MSFT	Stock	29.2	29.21	28.81	28.86	6539874.0
2010-05-14 10:00:00	MSFT	Stock	28.85	29.08	28.77	29.012	5155578.0
2010-05-14 10:30:00	MSFT	Stock	29.01	29.06	28.95	28.961	2956464.0
2010-05-14 11:00:00	MSFT	Stock	28.96	28.97	28.74	28.835	4524695.0
2010-05-14 11:30:00	MSFT	Stock	28.835	28.92	28.745	28.75	3766981.0
2010-05-14 12:00:00	MSFT	Stock	28.76	28.83	28.64	28.74	3031388.0
2010-05-14 12:30:00	MSFT	Stock	28.73	28.83	28.68	28.77	2883733.0
2010-05-14 13:00:00	MSFT	Stock	28.77	28.83	28.72	28.78	2519457.0
2010-05-14 13:30:00	MSFT	Stock	28.77	28.8	28.67	28.74	2360864.0
2010-05-14 14:00:00	MSFT	Stock	28.73	28.81	28.67	28.79	2581990.0
2010-05-14 14:30:00	MSFT	Stock	28.79	28.88	28.72	28.75	2591310.0
2010-05-14 15:00:00	MSFT	Stock	28.748	28.79	28.64	28.72	3449420.0
2010-05-14 15:30:00	MSFT	Stock	28.725	28.99	28.67	28.94	8655406.0
2010-05-14 16:00:00	MSFT	Stock	28.93	29.24	28.789	28.94	7116531.0

> showing 50 of 76,091 rows — these rows as CSV

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