PREVIEW / etf_30min / 2010-07-14

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-14.parquet
  size:    249 KB
  rows:    8,323

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-07-14 04:00:00	SPY	ETF	110.2	110.2	110.2	110.2	1000.0
2010-07-14 04:30:00	SPY	ETF	110.16	110.16	110.16	110.16	200.0
2010-07-14 05:00:00	SPY	ETF	110.18	110.18	110.07	110.07	14250.0
2010-07-14 05:30:00	SPY	ETF	110.05	110.05	109.85	109.85	6200.0
2010-07-14 06:00:00	SPY	ETF	109.8	109.98	109.8	109.96	17100.0
2010-07-14 06:30:00	SPY	ETF	109.96	109.96	109.82	109.82	42700.0
2010-07-14 07:00:00	SPY	ETF	109.83	109.87	109.65	109.82	182160.0
2010-07-14 07:30:00	SPY	ETF	109.82	109.89	109.73	109.77	231614.0
2010-07-14 08:00:00	SPY	ETF	109.78	109.835	109.53	109.57	832896.0
2010-07-14 08:30:00	SPY	ETF	109.57	109.83	109.39	109.4	2560919.0
2010-07-14 09:00:00	SPY	ETF	109.4	109.43	109.16	109.32	2276073.0
2010-07-14 09:30:00	SPY	ETF	109.31	109.47	109.09	109.19	21287936.0
2010-07-14 10:00:00	SPY	ETF	109.2	109.59	108.96	109.44	14671270.0
2010-07-14 10:30:00	SPY	ETF	109.44	109.67	109.2	109.6	11587135.0
2010-07-14 11:00:00	SPY	ETF	109.59	109.92	109.5	109.82	11484436.0
2010-07-14 11:30:00	SPY	ETF	109.81	110.08	109.8	109.89	8161370.0
2010-07-14 12:00:00	SPY	ETF	109.89	110.0	109.78	109.89	6346125.0
2010-07-14 12:30:00	SPY	ETF	109.89	109.96	109.67	109.7201	4849186.0
2010-07-14 13:00:00	SPY	ETF	109.7272	109.83	109.63	109.725	4688108.0
2010-07-14 13:30:00	SPY	ETF	109.725	109.81	109.35	109.44	8799499.0
2010-07-14 14:00:00	SPY	ETF	109.45	109.46	108.86	109.02	21515181.0
2010-07-14 14:30:00	SPY	ETF	109.03	109.33	108.95	109.29	11793115.0
2010-07-14 15:00:00	SPY	ETF	109.29	109.59	109.1	109.47	13157269.0
2010-07-14 15:30:00	SPY	ETF	109.46	109.69	109.14	109.66	27618927.0
2010-07-14 16:00:00	SPY	ETF	109.66	109.945	109.035	109.61	8346815.0
2010-07-14 16:30:00	SPY	ETF	109.64	109.74	109.59	109.68	1955142.0
2010-07-14 17:00:00	SPY	ETF	109.65	109.71	109.65	109.68	89102.0
2010-07-14 17:30:00	SPY	ETF	109.69	109.69	109.62	109.63	29913.0
2010-07-14 18:00:00	SPY	ETF	109.65	109.75	109.65	109.73	72771.0
2010-07-14 18:30:00	SPY	ETF	109.7	109.74	109.68	109.7	8850.0
2010-07-14 19:00:00	SPY	ETF	109.69	109.7	109.66	109.68	8200.0
2010-07-14 19:30:00	SPY	ETF	109.67	109.69	109.64	109.64	14670.0
2010-07-14 04:00:00	QQQ	ETF	45.81	45.83	45.81	45.83	10430.0
2010-07-14 04:30:00	QQQ	ETF	45.77	45.78	45.77	45.78	10130.0
2010-07-14 05:30:00	QQQ	ETF	45.7	45.7	45.7	45.7	2800.0
2010-07-14 06:00:00	QQQ	ETF	45.7	45.7	45.68	45.69	1100.0
2010-07-14 06:30:00	QQQ	ETF	45.71	45.71	45.71	45.71	100.0
2010-07-14 07:00:00	QQQ	ETF	45.71	45.71	45.62	45.7	63396.0
2010-07-14 07:30:00	QQQ	ETF	45.71	45.75	45.68	45.68	407498.0
2010-07-14 08:00:00	QQQ	ETF	45.69	45.71	45.54	45.57	425120.0
2010-07-14 08:30:00	QQQ	ETF	45.57	45.65	45.47	45.47	426085.0
2010-07-14 09:00:00	QQQ	ETF	45.47	45.48	45.4	45.42	1658793.0
2010-07-14 09:30:00	QQQ	ETF	45.41	45.58	45.36	45.399	10950716.0
2010-07-14 10:00:00	QQQ	ETF	45.4	45.6	45.29	45.52	9259770.0
2010-07-14 10:30:00	QQQ	ETF	45.52	45.61	45.45	45.52	7476731.0
2010-07-14 11:00:00	QQQ	ETF	45.52	45.72	45.46	45.68	6751074.0
2010-07-14 11:30:00	QQQ	ETF	45.67	45.81	45.67	45.76	4159957.0
2010-07-14 12:00:00	QQQ	ETF	45.76	45.765	45.68	45.74	2790681.0
2010-07-14 12:30:00	QQQ	ETF	45.733	45.78	45.66	45.6799	2451550.0
2010-07-14 13:00:00	QQQ	ETF	45.67	45.7	45.59	45.64	3154845.0

> showing 50 of 8,323 rows — these rows as CSV

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