PREVIEW / stock_30min / 2010-05-10

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-10.parquet
  size:    1.5 MB
  rows:    78,637
  symbols: 3,504

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-10 04:00:00	AAPL	Stock	9.1071	9.1429	8.9696	9.0889	166012.0
2010-05-10 04:30:00	AAPL	Stock	9.125	9.125	9.0036	9.0521	172592.0
2010-05-10 05:00:00	AAPL	Stock	9.0521	9.0521	8.9893	8.9893	161700.0
2010-05-10 05:30:00	AAPL	Stock	9.0204	9.0307	8.9475	9.0	223916.0
2010-05-10 06:00:00	AAPL	Stock	9.0	9.0029	8.9643	8.9911	192836.0
2010-05-10 06:30:00	AAPL	Stock	8.9911	8.9911	8.9643	8.975	218148.0
2010-05-10 07:00:00	AAPL	Stock	8.9643	9.0089	8.9443	9.0089	2389828.0
2010-05-10 07:30:00	AAPL	Stock	9.0086	9.0218	8.875	8.8907	2923508.0
2010-05-10 08:00:00	AAPL	Stock	8.8893	8.9275	8.8482	8.8929	8486072.0
2010-05-10 08:30:00	AAPL	Stock	8.8937	8.9029	8.8582	8.8596	6447644.0
2010-05-10 09:00:00	AAPL	Stock	8.8596	8.9346	8.8082	8.9346	13717620.0
2010-05-10 09:30:00	AAPL	Stock	8.9343	9.0179	8.8761	8.9443	237458480.0
2010-05-10 10:00:00	AAPL	Stock	8.9436	9.0654	8.9129	8.9846	149852108.0
2010-05-10 10:30:00	AAPL	Stock	8.985	9.0714	8.985	9.0409	76624184.0
2010-05-10 11:00:00	AAPL	Stock	9.0407	9.0639	9.0228	9.0568	45953068.0
2010-05-10 11:30:00	AAPL	Stock	9.0582	9.0946	9.0389	9.0685	47583956.0
2010-05-10 12:00:00	AAPL	Stock	9.0682	9.085	9.0461	9.048	31977708.0
2010-05-10 12:30:00	AAPL	Stock	9.0485	9.0671	9.0257	9.0396	29881348.0
2010-05-10 13:00:00	AAPL	Stock	9.0379	9.0511	8.9936	9.0261	57986852.0
2010-05-10 13:30:00	AAPL	Stock	9.0257	9.0521	9.0093	9.0391	36882748.0
2010-05-10 14:00:00	AAPL	Stock	9.0396	9.0536	9.0	9.0382	36498000.0
2010-05-10 14:30:00	AAPL	Stock	9.0361	9.0643	9.0075	9.0543	39492460.0
2010-05-10 15:00:00	AAPL	Stock	9.0518	9.0543	9.0036	9.0418	41103216.0
2010-05-10 15:30:00	AAPL	Stock	9.0407	9.0718	9.0107	9.0675	86471532.0
2010-05-10 16:00:00	AAPL	Stock	9.0661	9.0839	8.9704	9.075	23478952.0
2010-05-10 16:30:00	AAPL	Stock	9.0725	9.0725	9.0096	9.0682	2538368.0
2010-05-10 17:00:00	AAPL	Stock	9.0671	9.0714	9.0643	9.0704	137928.0
2010-05-10 17:30:00	AAPL	Stock	9.065	9.0705	9.065	9.0657	55440.0
2010-05-10 18:00:00	AAPL	Stock	9.0686	9.0839	9.0661	9.0839	316036.0
2010-05-10 18:30:00	AAPL	Stock	9.0807	9.1089	9.0807	9.1018	807492.0
2010-05-10 19:00:00	AAPL	Stock	9.1036	9.1064	9.0964	9.0964	278320.0
2010-05-10 19:30:00	AAPL	Stock	9.0929	9.0964	9.075	9.0771	676760.0
2010-05-10 04:00:00	MSFT	Stock	29.08	29.08	29.08	29.08	100.0
2010-05-10 04:30:00	MSFT	Stock	29.16	29.16	29.16	29.16	200.0
2010-05-10 05:30:00	MSFT	Stock	29.21	29.21	29.14	29.14	2850.0
2010-05-10 07:00:00	MSFT	Stock	29.03	29.18	28.95	29.07	32746.0
2010-05-10 07:30:00	MSFT	Stock	29.1	29.1	29.0	29.1	13529.0
2010-05-10 08:00:00	MSFT	Stock	29.06	29.14	29.0	29.1	120479.0
2010-05-10 08:30:00	MSFT	Stock	29.06	29.1	28.98	29.06	121695.0
2010-05-10 09:00:00	MSFT	Stock	29.06	29.2	28.97	29.01	167304.0
2010-05-10 09:30:00	MSFT	Stock	29.01	29.48	28.71	29.12	14258605.0
2010-05-10 10:00:00	MSFT	Stock	29.121	29.22	29.0	29.0	7458587.0
2010-05-10 10:30:00	MSFT	Stock	29.01	29.15	28.9	28.96	8423711.0
2010-05-10 11:00:00	MSFT	Stock	28.965	29.14	28.95	29.08	4884303.0
2010-05-10 11:30:00	MSFT	Stock	29.08	29.15	29.0	29.09	4198712.0
2010-05-10 12:00:00	MSFT	Stock	29.09	29.12	29.01	29.02	3166831.0
2010-05-10 12:30:00	MSFT	Stock	29.01	29.08	28.99	28.99	3098699.0
2010-05-10 13:00:00	MSFT	Stock	28.99	29.04	28.85	29.0	5612102.0
2010-05-10 13:30:00	MSFT	Stock	29.0	29.07	28.83	28.87	3723153.0
2010-05-10 14:00:00	MSFT	Stock	28.864	28.98	28.78	28.91	2862996.0

> showing 50 of 78,637 rows — these rows as CSV

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