PREVIEW / stock_30min / 2008-09-30

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-30.parquet
  size:    1.3 MB
  rows:    75,448
  symbols: 3,384

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-09-30 04:00:00	AAPL	Stock	3.7882	3.8211	3.7746	3.8032	133252.0
2008-09-30 04:30:00	AAPL	Stock	3.7786	3.7857	3.7786	3.7821	114800.0
2008-09-30 05:00:00	AAPL	Stock	3.7768	3.8	3.7768	3.7857	129220.0
2008-09-30 05:30:00	AAPL	Stock	3.7839	3.8214	3.7839	3.8214	149240.0
2008-09-30 06:00:00	AAPL	Stock	3.8214	3.8214	3.7857	3.795	218400.0
2008-09-30 06:30:00	AAPL	Stock	3.7861	3.8036	3.7743	3.7768	604128.0
2008-09-30 07:00:00	AAPL	Stock	3.7768	3.8029	3.7596	3.7911	1611316.0
2008-09-30 07:30:00	AAPL	Stock	3.7911	3.8293	3.79	3.8111	1754396.0
2008-09-30 08:00:00	AAPL	Stock	3.7857	3.8314	3.7589	3.8218	4950092.0
2008-09-30 08:30:00	AAPL	Stock	3.8225	3.8661	3.7996	3.8071	6071380.0
2008-09-30 09:00:00	AAPL	Stock	3.8057	3.8711	3.8054	3.8675	7672812.0
2008-09-30 09:30:00	AAPL	Stock	3.8661	3.9204	3.7964	3.8475	244556900.0
2008-09-30 10:00:00	AAPL	Stock	3.8475	3.9375	3.8418	3.9071	164164504.0
2008-09-30 10:30:00	AAPL	Stock	3.9071	3.9489	3.8875	3.8941	129688188.0
2008-09-30 11:00:00	AAPL	Stock	3.8939	3.9161	3.875	3.9082	85264088.0
2008-09-30 11:30:00	AAPL	Stock	3.9089	3.975	3.8911	3.9596	107054892.0
2008-09-30 12:00:00	AAPL	Stock	3.9596	3.9696	3.9154	3.9279	67841816.0
2008-09-30 12:30:00	AAPL	Stock	3.9279	3.9857	3.9204	3.9804	74687704.0
2008-09-30 13:00:00	AAPL	Stock	3.9804	4.0064	3.9579	3.9926	79660588.0
2008-09-30 13:30:00	AAPL	Stock	3.9929	4.0293	3.9893	3.9957	78082396.0
2008-09-30 14:00:00	AAPL	Stock	3.9954	4.0339	3.9857	4.0271	70456512.0
2008-09-30 14:30:00	AAPL	Stock	4.0275	4.0429	4.0029	4.0082	74755492.0
2008-09-30 15:00:00	AAPL	Stock	4.0082	4.0714	3.9993	4.0646	116279352.0
2008-09-30 15:30:00	AAPL	Stock	4.0646	4.1071	4.0085	4.0611	179380096.0
2008-09-30 16:00:00	AAPL	Stock	3.8821	4.1071	3.8821	4.0607	54088888.0
2008-09-30 16:30:00	AAPL	Stock	4.0596	4.0657	3.9528	3.9528	1555036.0
2008-09-30 17:00:00	AAPL	Stock	4.0586	4.0639	3.9563	4.0639	464352.0
2008-09-30 17:30:00	AAPL	Stock	4.0593	4.0621	3.9564	4.0607	12288836.0
2008-09-30 18:00:00	AAPL	Stock	4.0596	4.0693	4.0593	4.0629	184688.0
2008-09-30 18:30:00	AAPL	Stock	4.0629	4.0689	4.05	4.05	409360.0
2008-09-30 19:00:00	AAPL	Stock	4.0536	4.0661	4.05	4.0643	179620.0
2008-09-30 19:30:00	AAPL	Stock	4.0643	4.0714	4.0582	4.0707	308028.0
2008-09-30 04:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	100.0
2008-09-30 04:30:00	MSFT	Stock	25.23	25.23	25.22	25.22	1500.0
2008-09-30 05:30:00	MSFT	Stock	25.45	25.45	25.45	25.45	1000.0
2008-09-30 06:30:00	MSFT	Stock	25.36	25.53	25.36	25.43	8100.0
2008-09-30 07:00:00	MSFT	Stock	25.43	25.6	25.43	25.56	8150.0
2008-09-30 07:30:00	MSFT	Stock	25.52	25.52	25.45	25.51	9600.0
2008-09-30 08:00:00	MSFT	Stock	25.58	25.65	25.49	25.51	59591.0
2008-09-30 08:30:00	MSFT	Stock	25.5	25.7	25.45	25.66	72324.0
2008-09-30 09:00:00	MSFT	Stock	25.66	25.82	25.65	25.77	130531.0
2008-09-30 09:30:00	MSFT	Stock	25.77	26.0	25.54	25.7	9326030.0
2008-09-30 10:00:00	MSFT	Stock	25.69	25.89	25.57	25.71	6954159.0
2008-09-30 10:30:00	MSFT	Stock	25.71	25.98	25.66	25.81	5634088.0
2008-09-30 11:00:00	MSFT	Stock	25.81	25.84	25.68	25.76	6208795.0
2008-09-30 11:30:00	MSFT	Stock	25.76	25.84	25.7	25.83	5645454.0
2008-09-30 12:00:00	MSFT	Stock	25.82	25.87	25.66	25.69	3146530.0
2008-09-30 12:30:00	MSFT	Stock	25.7	25.82	25.692	25.735	4370954.0
2008-09-30 13:00:00	MSFT	Stock	25.74	25.99	25.66	25.95	5941878.0
2008-09-30 13:30:00	MSFT	Stock	25.94	26.32	25.92	26.07	9678027.0

> showing 50 of 75,448 rows — these rows as CSV

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