PREVIEW / etf_30min / 2009-04-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-16.parquet
  size:    216 KB
  rows:    7,157

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-04-16 04:00:00	SPY	ETF	84.56	84.66	84.55	84.66	9100.0
2009-04-16 04:30:00	SPY	ETF	84.88	84.88	84.88	84.88	300.0
2009-04-16 05:00:00	SPY	ETF	84.83	85.01	84.83	84.9	1300.0
2009-04-16 05:30:00	SPY	ETF	84.87	84.87	84.8	84.81	4300.0
2009-04-16 06:00:00	SPY	ETF	84.77	85.38	84.76	85.35	51500.0
2009-04-16 06:30:00	SPY	ETF	85.32	85.61	84.84	84.9	132568.0
2009-04-16 07:00:00	SPY	ETF	84.88	85.0	84.69	84.88	544637.0
2009-04-16 07:30:00	SPY	ETF	84.9	85.06	84.87	85.06	554557.0
2009-04-16 08:00:00	SPY	ETF	85.05	85.806	84.75	85.58	2761608.0
2009-04-16 08:30:00	SPY	ETF	85.59	85.96	84.53	85.9	6405172.0
2009-04-16 09:00:00	SPY	ETF	85.89	85.96	85.82	85.93	1956331.0
2009-04-16 09:30:00	SPY	ETF	85.93	85.97	85.07	85.45	26083882.0
2009-04-16 10:00:00	SPY	ETF	85.43	85.59	85.02	85.37	24132340.0
2009-04-16 10:30:00	SPY	ETF	85.37	85.54	84.77	84.9601	22417244.0
2009-04-16 11:00:00	SPY	ETF	84.96	85.24	84.91	85.23	14459664.0
2009-04-16 11:30:00	SPY	ETF	85.23	85.61	85.18	85.51	13680269.0
2009-04-16 12:00:00	SPY	ETF	85.51	85.68	85.38	85.43	6523750.0
2009-04-16 12:30:00	SPY	ETF	85.43	85.89	85.39	85.73	8771301.0
2009-04-16 13:00:00	SPY	ETF	85.74	85.93	85.62	85.79	10677995.0
2009-04-16 13:30:00	SPY	ETF	85.79	85.84	85.37	85.66	12615944.0
2009-04-16 14:00:00	SPY	ETF	85.66	86.15	85.65	86.13	17847148.0
2009-04-16 14:30:00	SPY	ETF	86.13	86.78	86.1	86.66	28079741.0
2009-04-16 15:00:00	SPY	ETF	86.67	87.11	86.55	86.87	33349109.0
2009-04-16 15:30:00	SPY	ETF	86.87	87.15	86.45	86.56	48698858.0
2009-04-16 16:00:00	SPY	ETF	86.55	87.2	85.0201	86.66	15525115.0
2009-04-16 16:30:00	SPY	ETF	86.63	86.67	85.2964	86.33	11618380.0
2009-04-16 17:00:00	SPY	ETF	86.32	86.35	85.2965	86.28	4287631.0
2009-04-16 17:30:00	SPY	ETF	86.29	86.38	86.18	86.25	101607.0
2009-04-16 18:00:00	SPY	ETF	86.25	86.36	86.25	86.36	38881.0
2009-04-16 18:30:00	SPY	ETF	86.36	86.4	86.33	86.38	27376.0
2009-04-16 19:00:00	SPY	ETF	86.39	86.41	86.37	86.37	9722.0
2009-04-16 19:30:00	SPY	ETF	86.37	86.41	86.35	86.41	60708.0
2009-04-16 04:00:00	QQQ	ETF	32.22	32.22	32.22	32.22	690.0
2009-04-16 06:00:00	QQQ	ETF	32.48	32.51	32.47	32.51	4950.0
2009-04-16 06:30:00	QQQ	ETF	32.51	32.56	32.34	32.34	48350.0
2009-04-16 07:00:00	QQQ	ETF	32.38	32.5	32.31	32.46	824569.0
2009-04-16 07:30:00	QQQ	ETF	32.47	32.49	32.44	32.49	157657.0
2009-04-16 08:00:00	QQQ	ETF	32.49	32.78	32.37	32.78	6974143.0
2009-04-16 08:30:00	QQQ	ETF	32.79	32.94	32.71	32.89	3822916.0
2009-04-16 09:00:00	QQQ	ETF	32.89	32.92	32.81	32.82	1614302.0
2009-04-16 09:30:00	QQQ	ETF	32.83	32.86	32.63	32.8099	16412190.0
2009-04-16 10:00:00	QQQ	ETF	32.8	32.86	32.68	32.8	12803881.0
2009-04-16 10:30:00	QQQ	ETF	32.8	32.87	32.51	32.58	12462393.0
2009-04-16 11:00:00	QQQ	ETF	32.58	32.69	32.5799	32.68	4869161.0
2009-04-16 11:30:00	QQQ	ETF	32.68	32.82	32.66	32.78	5554006.0
2009-04-16 12:00:00	QQQ	ETF	32.78	32.88	32.76	32.7701	4795322.0
2009-04-16 12:30:00	QQQ	ETF	32.77	32.97	32.77	32.912	4615876.0
2009-04-16 13:00:00	QQQ	ETF	32.91	32.97	32.86	32.95	5085262.0
2009-04-16 13:30:00	QQQ	ETF	32.94	32.97	32.8	32.918	7065374.0
2009-04-16 14:00:00	QQQ	ETF	32.92	33.07	32.91	33.05	8928965.0

> showing 50 of 7,157 rows — these rows as CSV

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