PREVIEW / stock_30min / 2009-07-07

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-07-07.parquet
  size:    1.3 MB
  rows:    70,754
  symbols: 3,327

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-07-07 08:00:00	AAPL	Stock	4.9725	4.9725	4.9529	4.9582	605864.0
2009-07-07 08:30:00	AAPL	Stock	4.96	4.9679	4.9561	4.9607	365848.0
2009-07-07 09:00:00	AAPL	Stock	4.9614	4.9643	4.9436	4.9439	1388688.0
2009-07-07 09:30:00	AAPL	Stock	4.9443	4.9886	4.9325	4.9496	69728204.0
2009-07-07 10:00:00	AAPL	Stock	4.95	4.9511	4.8939	4.9182	42690620.0
2009-07-07 10:30:00	AAPL	Stock	4.9175	4.9175	4.8821	4.8911	27196512.0
2009-07-07 11:00:00	AAPL	Stock	4.89	4.8989	4.875	4.875	35432376.0
2009-07-07 11:30:00	AAPL	Stock	4.875	4.8814	4.8536	4.8696	35063700.0
2009-07-07 12:00:00	AAPL	Stock	4.8696	4.8725	4.8618	4.8639	18055744.0
2009-07-07 12:30:00	AAPL	Stock	4.8636	4.8675	4.8436	4.8596	24595676.0
2009-07-07 13:00:00	AAPL	Stock	4.8604	4.8825	4.8572	4.8727	24879876.0
2009-07-07 13:30:00	AAPL	Stock	4.8736	4.8857	4.8711	4.8846	23007012.0
2009-07-07 14:00:00	AAPL	Stock	4.8854	4.8882	4.8682	4.8796	19099304.0
2009-07-07 14:30:00	AAPL	Stock	4.8799	4.8882	4.8607	4.8632	24291036.0
2009-07-07 15:00:00	AAPL	Stock	4.8629	4.8636	4.84	4.855	37117388.0
2009-07-07 15:30:00	AAPL	Stock	4.8541	4.8675	4.8279	4.835	65973880.0
2009-07-07 16:00:00	AAPL	Stock	4.8343	4.9445	4.8305	4.8357	8570016.0
2009-07-07 16:30:00	AAPL	Stock	4.8357	4.8464	4.8357	4.8464	1004948.0
2009-07-07 17:00:00	AAPL	Stock	4.8446	4.8536	4.8446	4.8525	318360.0
2009-07-07 17:30:00	AAPL	Stock	4.8482	4.8521	4.8421	4.8464	53760.0
2009-07-07 18:00:00	AAPL	Stock	4.8321	4.8457	4.8314	4.8411	972328.0
2009-07-07 18:30:00	AAPL	Stock	4.8407	4.8429	4.84	4.8429	23660.0
2009-07-07 19:00:00	AAPL	Stock	4.8411	4.8411	4.8404	4.8411	37660.0
2009-07-07 19:30:00	AAPL	Stock	4.8411	4.8464	4.84	4.8464	98476.0
2009-07-07 07:30:00	MSFT	Stock	23.32	23.32	23.3	23.3	1210.0
2009-07-07 08:00:00	MSFT	Stock	23.26	23.26	23.15	23.2	6000.0
2009-07-07 08:30:00	MSFT	Stock	23.12	23.23	23.12	23.15	7540.0
2009-07-07 09:00:00	MSFT	Stock	23.11	23.15	23.04	23.04	28369.0
2009-07-07 09:30:00	MSFT	Stock	23.07	23.14	22.95	22.992	6003917.0
2009-07-07 10:00:00	MSFT	Stock	22.99	23.0	22.82	22.87	4434723.0
2009-07-07 10:30:00	MSFT	Stock	22.86	22.88	22.8	22.84	2959287.0
2009-07-07 11:00:00	MSFT	Stock	22.85	22.85	22.76	22.77	2620762.0
2009-07-07 11:30:00	MSFT	Stock	22.77	22.79	22.69	22.762	3337782.0
2009-07-07 12:00:00	MSFT	Stock	22.767	22.8	22.71	22.788	2469538.0
2009-07-07 12:30:00	MSFT	Stock	22.782	22.8	22.74	22.75	1852665.0
2009-07-07 13:00:00	MSFT	Stock	22.75	22.82	22.75	22.8	1802482.0
2009-07-07 13:30:00	MSFT	Stock	22.81	22.85	22.73	22.768	2567481.0
2009-07-07 14:00:00	MSFT	Stock	22.77	22.8	22.71	22.792	2084989.0
2009-07-07 14:30:00	MSFT	Stock	22.79	22.81	22.65	22.7	3537546.0
2009-07-07 15:00:00	MSFT	Stock	22.69	22.7	22.56	22.593	4860560.0
2009-07-07 15:30:00	MSFT	Stock	22.59	22.62	22.46	22.54	10397831.0
2009-07-07 16:00:00	MSFT	Stock	22.54	23.364	22.5	22.52	2089692.0
2009-07-07 16:30:00	MSFT	Stock	22.52	22.54	22.51	22.52	193599.0
2009-07-07 17:00:00	MSFT	Stock	22.53	22.53	22.51	22.51	13200.0
2009-07-07 17:30:00	MSFT	Stock	22.53	22.53	22.5	22.52	5850.0
2009-07-07 18:00:00	MSFT	Stock	22.53	22.53	22.5	22.5	17562.0
2009-07-07 18:30:00	MSFT	Stock	22.5	22.52	22.5	22.5	4781.0
2009-07-07 19:00:00	MSFT	Stock	22.49	22.5	22.49	22.5	1952.0
2009-07-07 19:30:00	MSFT	Stock	22.5	22.53	22.49	22.53	2089.0
2009-07-07 06:00:00	NVDA	Stock	0.2663	0.2663	0.2663	0.2663	40000.0

> showing 50 of 70,754 rows — these rows as CSV

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