PREVIEW / etf_30min / 2010-07-30

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-30.parquet
  size:    247 KB
  rows:    8,197

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-30 04:00:00	SPY	ETF	109.94	109.97	109.86	109.97	2000.0
2010-07-30 04:30:00	SPY	ETF	109.88	109.88	109.88	109.88	100.0
2010-07-30 05:00:00	SPY	ETF	109.89	109.89	109.67	109.67	2894.0
2010-07-30 05:30:00	SPY	ETF	109.75	109.75	109.6	109.6	1750.0
2010-07-30 06:00:00	SPY	ETF	109.6	109.6	109.6	109.6	100.0
2010-07-30 06:30:00	SPY	ETF	109.73	109.86	109.73	109.81	27000.0
2010-07-30 07:00:00	SPY	ETF	109.85	109.85	109.71	109.77	38420.0
2010-07-30 07:30:00	SPY	ETF	109.85	109.85	109.68	109.75	106504.0
2010-07-30 08:00:00	SPY	ETF	109.75	109.76	109.6	109.62	364519.0
2010-07-30 08:30:00	SPY	ETF	109.72	109.72	108.89	109.1	6191620.0
2010-07-30 09:00:00	SPY	ETF	109.1	109.26	109.03	109.18	1888891.0
2010-07-30 09:30:00	SPY	ETF	109.17	109.84	108.98	109.66	41584062.0
2010-07-30 10:00:00	SPY	ETF	109.67	110.18	109.64	110.029	17255074.0
2010-07-30 10:30:00	SPY	ETF	110.03	110.64	110.0	110.37	18832857.0
2010-07-30 11:00:00	SPY	ETF	110.37	110.56	110.04	110.1	9401967.0
2010-07-30 11:30:00	SPY	ETF	110.09	110.4	109.97	110.27	8343414.0
2010-07-30 12:00:00	SPY	ETF	110.27	110.34	110.04	110.2	6282219.0
2010-07-30 12:30:00	SPY	ETF	110.2	110.3	110.01	110.2499	3948424.0
2010-07-30 13:00:00	SPY	ETF	110.245	110.31	109.88	110.029	6892740.0
2010-07-30 13:30:00	SPY	ETF	110.02	110.25	109.56	109.61	9880726.0
2010-07-30 14:00:00	SPY	ETF	109.6	110.23	109.57	110.15	12111358.0
2010-07-30 14:30:00	SPY	ETF	110.15	110.3	109.97	110.04	11805873.0
2010-07-30 15:00:00	SPY	ETF	110.04	110.86	109.96	110.73	18887437.0
2010-07-30 15:30:00	SPY	ETF	110.7226	110.86	110.29	110.32	30335756.0
2010-07-30 16:00:00	SPY	ETF	110.32	110.56	109.1096	110.49	6812676.0
2010-07-30 16:30:00	SPY	ETF	110.5	110.52	110.29	110.48	6509009.0
2010-07-30 17:00:00	SPY	ETF	110.45	110.6	110.42	110.57	257225.0
2010-07-30 17:30:00	SPY	ETF	110.6	110.61	110.51	110.55	54796.0
2010-07-30 18:00:00	SPY	ETF	110.55	110.55	110.35	110.44	150059.0
2010-07-30 18:30:00	SPY	ETF	110.42	110.46	110.27	110.41	7286.0
2010-07-30 19:00:00	SPY	ETF	110.43	110.44	110.4	110.4	10130.0
2010-07-30 19:30:00	SPY	ETF	110.43	110.46	110.4	110.43	19632.0
2010-07-30 04:00:00	QQQ	ETF	45.59	45.59	45.51	45.52	828.0
2010-07-30 04:30:00	QQQ	ETF	45.56	45.56	45.5	45.5	360.0
2010-07-30 05:00:00	QQQ	ETF	45.5	45.5	45.5	45.5	100.0
2010-07-30 06:30:00	QQQ	ETF	45.58	45.58	45.57	45.57	366.0
2010-07-30 07:00:00	QQQ	ETF	45.58	45.58	45.5	45.53	9229.0
2010-07-30 07:30:00	QQQ	ETF	45.51	45.56	45.51	45.54	10048.0
2010-07-30 08:00:00	QQQ	ETF	45.54	45.87	45.4	45.4	131887.0
2010-07-30 08:30:00	QQQ	ETF	45.39	45.48	45.14	45.25	653644.0
2010-07-30 09:00:00	QQQ	ETF	45.25	45.37	45.25	45.36	1140972.0
2010-07-30 09:30:00	QQQ	ETF	45.36	45.39	45.07	45.32	21066545.0
2010-07-30 10:00:00	QQQ	ETF	45.32	45.63	45.3	45.529	9887067.0
2010-07-30 10:30:00	QQQ	ETF	45.53	45.9	45.52	45.77	9915123.0
2010-07-30 11:00:00	QQQ	ETF	45.77	45.83	45.64	45.65	4668152.0
2010-07-30 11:30:00	QQQ	ETF	45.65	45.82	45.61	45.77	3639151.0
2010-07-30 12:00:00	QQQ	ETF	45.77	45.8	45.66	45.76	2607296.0
2010-07-30 12:30:00	QQQ	ETF	45.76	45.84	45.71	45.81	1423505.0
2010-07-30 13:00:00	QQQ	ETF	45.82	45.85	45.62	45.69	1850474.0
2010-07-30 13:30:00	QQQ	ETF	45.69	45.69	45.5	45.52	1920002.0

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

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