PREVIEW / etf_30min / 2010-08-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-17.parquet
  size:    255 KB
  rows:    8,446

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-08-17 04:00:00	SPY	ETF	108.64	108.81	108.64	108.81	2412.0
2010-08-17 04:30:00	SPY	ETF	108.89	108.99	108.86	108.97	2500.0
2010-08-17 05:00:00	SPY	ETF	108.81	109.0	108.81	108.99	6900.0
2010-08-17 05:30:00	SPY	ETF	108.87	108.9	108.87	108.9	2100.0
2010-08-17 06:00:00	SPY	ETF	108.94	109.12	108.94	109.12	2600.0
2010-08-17 06:30:00	SPY	ETF	109.14	109.14	109.0	109.0	26850.0
2010-08-17 07:00:00	SPY	ETF	108.98	109.03	108.87	109.0	320200.0
2010-08-17 07:30:00	SPY	ETF	109.0	109.05	108.9	108.95	284478.0
2010-08-17 08:00:00	SPY	ETF	109.19	109.19	108.82	108.83	871250.0
2010-08-17 08:30:00	SPY	ETF	108.86	109.22	108.79	109.04	2013787.0
2010-08-17 09:00:00	SPY	ETF	109.05	111.17	108.83	109.18	2091206.0
2010-08-17 09:30:00	SPY	ETF	109.19	109.295	108.88	109.085	20325679.0
2010-08-17 10:00:00	SPY	ETF	109.085	109.22	108.91	109.01	11744178.0
2010-08-17 10:30:00	SPY	ETF	109.01	109.49	108.98	109.43	14620324.0
2010-08-17 11:00:00	SPY	ETF	109.43	109.94	109.2	109.86	17311780.0
2010-08-17 11:30:00	SPY	ETF	109.86	110.08	109.83	110.0317	9853281.0
2010-08-17 12:00:00	SPY	ETF	110.0301	110.04	109.85	109.88	7528812.0
2010-08-17 12:30:00	SPY	ETF	109.87	109.99	109.86	109.9028	4251460.0
2010-08-17 13:00:00	SPY	ETF	109.91	110.32	109.9	110.32	8899490.0
2010-08-17 13:30:00	SPY	ETF	110.32	110.39	110.1	110.19	7945480.0
2010-08-17 14:00:00	SPY	ETF	110.19	110.28	110.15	110.2401	4628432.0
2010-08-17 14:30:00	SPY	ETF	110.2401	110.27	110.09	110.13	5765493.0
2010-08-17 15:00:00	SPY	ETF	110.13	110.13	109.88	110.09	12288664.0
2010-08-17 15:30:00	SPY	ETF	110.09	110.1	109.55	109.6	26861393.0
2010-08-17 16:00:00	SPY	ETF	109.59	110.295	108.2959	109.48	9466073.0
2010-08-17 16:30:00	SPY	ETF	109.46	109.9373	109.39	109.5	303058.0
2010-08-17 17:00:00	SPY	ETF	109.51	109.51	109.44	109.46	71195.0
2010-08-17 17:30:00	SPY	ETF	109.44	109.49	108.26	108.26	35072.0
2010-08-17 18:00:00	SPY	ETF	109.46	109.59	109.44	109.53	61760.0
2010-08-17 18:30:00	SPY	ETF	109.53	109.57	109.52	109.55	36778.0
2010-08-17 19:00:00	SPY	ETF	109.52	109.55	109.47	109.52	13400.0
2010-08-17 19:30:00	SPY	ETF	109.5	109.51	109.45	109.49	20900.0
2010-08-17 04:00:00	QQQ	ETF	45.0	45.0	44.99	44.99	205.0
2010-08-17 05:00:00	QQQ	ETF	45.04	45.06	45.04	45.06	200.0
2010-08-17 05:30:00	QQQ	ETF	45.03	45.03	45.03	45.03	675.0
2010-08-17 06:00:00	QQQ	ETF	45.03	45.03	45.03	45.03	1200.0
2010-08-17 06:30:00	QQQ	ETF	45.05	45.05	45.03	45.03	250.0
2010-08-17 07:00:00	QQQ	ETF	45.01	45.05	45.0	45.05	54724.0
2010-08-17 07:30:00	QQQ	ETF	45.02	45.06	45.01	45.02	12775.0
2010-08-17 08:00:00	QQQ	ETF	45.0	45.05	45.0	45.04	164399.0
2010-08-17 08:30:00	QQQ	ETF	45.03	45.14	44.95	45.07	370415.0
2010-08-17 09:00:00	QQQ	ETF	45.07	45.18	45.04	45.12	655105.0
2010-08-17 09:30:00	QQQ	ETF	45.11	45.25	45.03	45.19	4908417.0
2010-08-17 10:00:00	QQQ	ETF	45.185	45.28	45.13	45.195	3376248.0
2010-08-17 10:30:00	QQQ	ETF	45.2	45.36	45.18	45.33	4118722.0
2010-08-17 11:00:00	QQQ	ETF	45.34	45.58	45.33	45.5399	6039913.0
2010-08-17 11:30:00	QQQ	ETF	45.53	45.64	45.53	45.6	2853154.0
2010-08-17 12:00:00	QQQ	ETF	45.6005	45.62	45.54	45.541	1744687.0
2010-08-17 12:30:00	QQQ	ETF	45.54	45.61	45.2	45.58	1152605.0
2010-08-17 13:00:00	QQQ	ETF	45.585	45.78	45.58	45.75	3818393.0

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

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