PREVIEW / etf_30min / 2010-07-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-16.parquet
  size:    256 KB
  rows:    8,459

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-16 04:00:00	SPY	ETF	109.37	109.42	109.35	109.4	2900.0
2010-07-16 04:30:00	SPY	ETF	109.42	109.42	109.34	109.34	2300.0
2010-07-16 05:00:00	SPY	ETF	109.37	109.37	109.37	109.37	2000.0
2010-07-16 05:30:00	SPY	ETF	109.52	109.75	109.46	109.75	6873.0
2010-07-16 06:00:00	SPY	ETF	109.77	109.77	109.72	109.73	4600.0
2010-07-16 06:30:00	SPY	ETF	109.87	109.96	109.83	109.88	47500.0
2010-07-16 07:00:00	SPY	ETF	109.8	109.99	109.75	109.95	506155.0
2010-07-16 07:30:00	SPY	ETF	109.94	109.94	109.53	109.61	553774.0
2010-07-16 08:00:00	SPY	ETF	109.86	109.86	109.12	109.38	1847943.0
2010-07-16 08:30:00	SPY	ETF	109.28	109.68	109.28	109.33	2334353.0
2010-07-16 09:00:00	SPY	ETF	109.34	109.59	108.98	109.08	3560802.0
2010-07-16 09:30:00	SPY	ETF	109.09	109.2059	107.9	108.05	34952623.0
2010-07-16 10:00:00	SPY	ETF	108.05	108.12	107.57	107.93	27946170.0
2010-07-16 10:30:00	SPY	ETF	107.925	108.124	107.75	108.06	14698692.0
2010-07-16 11:00:00	SPY	ETF	108.06	108.12	107.48	107.73	16613391.0
2010-07-16 11:30:00	SPY	ETF	107.72	107.74	107.32	107.36	13292233.0
2010-07-16 12:00:00	SPY	ETF	107.37	107.58	107.16	107.38	13157583.0
2010-07-16 12:30:00	SPY	ETF	107.38	107.4	107.11	107.17	8396359.0
2010-07-16 13:00:00	SPY	ETF	107.1726	107.34	107.07	107.11	12719624.0
2010-07-16 13:30:00	SPY	ETF	107.11	107.43	106.92	107.03	14234861.0
2010-07-16 14:00:00	SPY	ETF	107.03	107.22	106.89	107.03	10039133.0
2010-07-16 14:30:00	SPY	ETF	107.03	107.12	106.85	106.9	11428521.0
2010-07-16 15:00:00	SPY	ETF	106.9	107.03	106.45	106.6	23509939.0
2010-07-16 15:30:00	SPY	ETF	106.6	106.93	106.47	106.66	51907922.0
2010-07-16 16:00:00	SPY	ETF	106.66	109.7908	106.485	106.91	13584770.0
2010-07-16 16:30:00	SPY	ETF	106.91	106.93	106.8	106.85	5123908.0
2010-07-16 17:00:00	SPY	ETF	106.84	109.7907	106.62	106.68	1217842.0
2010-07-16 17:30:00	SPY	ETF	106.68	106.75	106.63	106.68	74578.0
2010-07-16 18:00:00	SPY	ETF	106.67	106.75	106.63	106.67	31443.0
2010-07-16 18:30:00	SPY	ETF	106.71	106.76	106.7	106.74	6930.0
2010-07-16 19:00:00	SPY	ETF	106.74	106.78	106.7	106.72	21995.0
2010-07-16 19:30:00	SPY	ETF	106.71	106.74	106.62	106.62	25790.0
2010-07-16 05:00:00	QQQ	ETF	45.45	45.45	45.45	45.45	500.0
2010-07-16 05:30:00	QQQ	ETF	45.56	45.56	45.56	45.56	500.0
2010-07-16 06:00:00	QQQ	ETF	45.56	45.59	45.56	45.59	7000.0
2010-07-16 07:00:00	QQQ	ETF	45.62	45.65	45.62	45.64	39161.0
2010-07-16 07:30:00	QQQ	ETF	45.62	45.62	45.54	45.56	80702.0
2010-07-16 08:00:00	QQQ	ETF	45.56	45.56	45.47	45.53	376573.0
2010-07-16 08:30:00	QQQ	ETF	45.52	45.6	45.48	45.49	286437.0
2010-07-16 09:00:00	QQQ	ETF	45.49	45.51	45.37	45.44	825331.0
2010-07-16 09:30:00	QQQ	ETF	45.44	45.5	45.02	45.0734	16278510.0
2010-07-16 10:00:00	QQQ	ETF	45.07	45.09	44.77	44.93	10516707.0
2010-07-16 10:30:00	QQQ	ETF	44.93	44.99	44.82	44.94	3846571.0
2010-07-16 11:00:00	QQQ	ETF	44.93	44.97	44.71	44.82	3772696.0
2010-07-16 11:30:00	QQQ	ETF	44.83	44.83	44.59	44.61	4678949.0
2010-07-16 12:00:00	QQQ	ETF	44.6	44.7	44.52	44.59	4650385.0
2010-07-16 12:30:00	QQQ	ETF	44.59	45.6281	44.55	44.56	3508336.0
2010-07-16 13:00:00	QQQ	ETF	44.56	45.6281	44.5	44.57	6942792.0
2010-07-16 13:30:00	QQQ	ETF	44.56	44.79	44.46	44.52	8746501.0
2010-07-16 14:00:00	QQQ	ETF	44.52	44.62	44.47	44.56	5584340.0

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

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