PREVIEW / etf_30min / 2010-07-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-28.parquet
  size:    244 KB
  rows:    8,049

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-28 04:00:00	SPY	ETF	111.66	111.82	111.66	111.82	1000.0
2010-07-28 04:30:00	SPY	ETF	111.84	111.85	111.84	111.85	300.0
2010-07-28 05:00:00	SPY	ETF	111.88	111.88	111.88	111.88	300.0
2010-07-28 05:30:00	SPY	ETF	111.77	111.77	111.64	111.67	5082.0
2010-07-28 06:00:00	SPY	ETF	111.63	111.63	111.4	111.4	20350.0
2010-07-28 06:30:00	SPY	ETF	111.43	111.6	111.4	111.6	11112.0
2010-07-28 07:00:00	SPY	ETF	111.59	111.71	111.51	111.71	164213.0
2010-07-28 07:30:00	SPY	ETF	111.71	111.82	111.61	111.79	128390.0
2010-07-28 08:00:00	SPY	ETF	111.57	111.79	110.404	111.67	597510.0
2010-07-28 08:30:00	SPY	ETF	111.68	111.76	111.22	111.43	4071766.0
2010-07-28 09:00:00	SPY	ETF	111.44	111.49	111.27	111.33	2439522.0
2010-07-28 09:30:00	SPY	ETF	111.32	111.66	111.16	111.4	16676453.0
2010-07-28 10:00:00	SPY	ETF	111.3983	111.51	110.96	111.17	13724405.0
2010-07-28 10:30:00	SPY	ETF	111.17	111.4	110.87	111.2	12594784.0
2010-07-28 11:00:00	SPY	ETF	111.21	111.23	110.92	111.08	8103730.0
2010-07-28 11:30:00	SPY	ETF	111.08	111.26	110.9647	111.06	8048712.0
2010-07-28 12:00:00	SPY	ETF	111.06	111.27	110.99	111.13	4691761.0
2010-07-28 12:30:00	SPY	ETF	111.13	111.39	111.08	111.38	7477042.0
2010-07-28 13:00:00	SPY	ETF	111.38	111.44	111.16	111.21	8900351.0
2010-07-28 13:30:00	SPY	ETF	111.2	111.23	111.02	111.18	8527428.0
2010-07-28 14:00:00	SPY	ETF	111.18	111.31	110.78	110.94	13707140.0
2010-07-28 14:30:00	SPY	ETF	110.93	111.06	110.75	110.82	6962722.0
2010-07-28 15:00:00	SPY	ETF	110.84	110.93	110.46	110.69	16053035.0
2010-07-28 15:30:00	SPY	ETF	110.69	110.9	110.69	110.81	19258187.0
2010-07-28 16:00:00	SPY	ETF	110.8	111.555	110.7	110.79	10428594.0
2010-07-28 16:30:00	SPY	ETF	110.78	110.84	110.76	110.77	76860.0
2010-07-28 17:00:00	SPY	ETF	110.77	110.77	110.64	110.68	155298.0
2010-07-28 17:30:00	SPY	ETF	110.7	110.75	110.69	110.73	10236.0
2010-07-28 18:00:00	SPY	ETF	110.71	110.8	110.7	110.71	79809.0
2010-07-28 18:30:00	SPY	ETF	110.71	110.74	110.71	110.71	25234.0
2010-07-28 19:00:00	SPY	ETF	110.72	110.81	110.72	110.79	36944.0
2010-07-28 19:30:00	SPY	ETF	110.79	110.88	110.79	110.83	40124.0
2010-07-28 05:00:00	QQQ	ETF	46.56	46.57	46.56	46.57	11000.0
2010-07-28 06:00:00	QQQ	ETF	46.44	46.44	46.37	46.37	500.0
2010-07-28 06:30:00	QQQ	ETF	46.35	46.4	46.34	46.4	10535.0
2010-07-28 07:00:00	QQQ	ETF	46.42	46.48	46.4	46.48	63800.0
2010-07-28 07:30:00	QQQ	ETF	46.47	46.53	46.47	46.53	14059.0
2010-07-28 08:00:00	QQQ	ETF	46.3597	46.54	46.3597	46.51	62613.0
2010-07-28 08:30:00	QQQ	ETF	46.5	46.5	46.26	46.35	1008526.0
2010-07-28 09:00:00	QQQ	ETF	46.35	46.42	46.32	46.38	504753.0
2010-07-28 09:30:00	QQQ	ETF	46.38	46.58	46.37	46.5201	5293308.0
2010-07-28 10:00:00	QQQ	ETF	46.525	46.57	46.26	46.33	4633811.0
2010-07-28 10:30:00	QQQ	ETF	46.33	46.38	46.2	46.31	3905566.0
2010-07-28 11:00:00	QQQ	ETF	46.3	46.32	46.17	46.25	2918290.0
2010-07-28 11:30:00	QQQ	ETF	46.25	46.31	46.18	46.2101	2608390.0
2010-07-28 12:00:00	QQQ	ETF	46.22	46.31	46.2	46.23	1443246.0
2010-07-28 12:30:00	QQQ	ETF	46.23	46.3	46.19	46.3	1645558.0
2010-07-28 13:00:00	QQQ	ETF	46.3	46.32	46.13	46.16	2463412.0
2010-07-28 13:30:00	QQQ	ETF	46.16	46.17	46.07	46.11	1873850.0
2010-07-28 14:00:00	QQQ	ETF	46.11	46.18	46.0	46.06	4558046.0

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

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