PREVIEW / etf_30min / 2009-05-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-05.parquet
  size:    218 KB
  rows:    7,317

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
2009-05-05 04:00:00	SPY	ETF	90.39	90.45	90.35	90.38	4175.0
2009-05-05 04:30:00	SPY	ETF	90.5	90.69	90.5	90.69	900.0
2009-05-05 05:00:00	SPY	ETF	90.67	90.85	90.67	90.85	12000.0
2009-05-05 05:30:00	SPY	ETF	90.86	90.97	90.86	90.89	12101.0
2009-05-05 06:00:00	SPY	ETF	90.83	90.84	90.73	90.73	18500.0
2009-05-05 06:30:00	SPY	ETF	90.71	90.77	90.71	90.77	15170.0
2009-05-05 07:00:00	SPY	ETF	90.79	90.85	90.41	90.45	300154.0
2009-05-05 07:30:00	SPY	ETF	90.47	90.55	90.32	90.39	576287.0
2009-05-05 08:00:00	SPY	ETF	90.39	90.54	90.28	90.35	1148529.0
2009-05-05 08:30:00	SPY	ETF	90.35	90.46	90.33	90.4	433186.0
2009-05-05 09:00:00	SPY	ETF	90.4	90.59	90.4	90.56	999821.0
2009-05-05 09:30:00	SPY	ETF	90.57	90.93	90.37	90.67	30076601.0
2009-05-05 10:00:00	SPY	ETF	90.67	90.9	90.36	90.4778	28662124.0
2009-05-05 10:30:00	SPY	ETF	90.48	90.48	89.88	89.8874	21024542.0
2009-05-05 11:00:00	SPY	ETF	89.8801	90.22	89.88	90.17	12945178.0
2009-05-05 11:30:00	SPY	ETF	90.17	90.46	90.05	90.35	14418122.0
2009-05-05 12:00:00	SPY	ETF	90.35	90.46	90.26	90.41	7043727.0
2009-05-05 12:30:00	SPY	ETF	90.41	90.42	90.08	90.205	7831529.0
2009-05-05 13:00:00	SPY	ETF	90.2	90.41	90.02	90.08	10631291.0
2009-05-05 13:30:00	SPY	ETF	90.08	90.29	89.97	90.21	11480903.0
2009-05-05 14:00:00	SPY	ETF	90.218	90.39	89.88	89.89	14828145.0
2009-05-05 14:30:00	SPY	ETF	89.89	90.26	89.84	90.06	13505573.0
2009-05-05 15:00:00	SPY	ETF	90.06	90.37	90.03	90.27	25092265.0
2009-05-05 15:30:00	SPY	ETF	90.27	90.69	90.27	90.51	28231269.0
2009-05-05 16:00:00	SPY	ETF	90.52	90.85	90.08	90.77	8780295.0
2009-05-05 16:30:00	SPY	ETF	90.75	90.82	90.72	90.79	3738965.0
2009-05-05 17:00:00	SPY	ETF	90.81	90.87	90.76	90.83	164547.0
2009-05-05 17:30:00	SPY	ETF	90.83	90.87	90.8	90.83	14630.0
2009-05-05 18:00:00	SPY	ETF	90.84	90.84	90.75	90.81	14675.0
2009-05-05 18:30:00	SPY	ETF	90.81	90.91	90.81	90.86	51250.0
2009-05-05 19:00:00	SPY	ETF	90.85	90.85	90.74	90.75	21706.0
2009-05-05 19:30:00	SPY	ETF	90.75	90.78	90.73	90.76	27387.0
2009-05-05 04:30:00	QQQ	ETF	35.0	35.06	35.0	35.06	200.0
2009-05-05 05:00:00	QQQ	ETF	35.08	35.08	35.08	35.08	100.0
2009-05-05 05:30:00	QQQ	ETF	35.11	35.12	35.09	35.09	300.0
2009-05-05 06:00:00	QQQ	ETF	35.05	35.05	35.05	35.05	100.0
2009-05-05 06:30:00	QQQ	ETF	35.08	35.09	35.08	35.09	5378.0
2009-05-05 07:00:00	QQQ	ETF	35.09	35.09	34.94	34.94	170908.0
2009-05-05 07:30:00	QQQ	ETF	34.95	35.02	34.94	34.97	225301.0
2009-05-05 08:00:00	QQQ	ETF	34.95	35.0	34.93	34.96	360451.0
2009-05-05 08:30:00	QQQ	ETF	34.96	34.99	34.95	34.97	400850.0
2009-05-05 09:00:00	QQQ	ETF	34.97	35.02	34.97	35.0	471834.0
2009-05-05 09:30:00	QQQ	ETF	34.99	35.06	34.8	34.92	15992898.0
2009-05-05 10:00:00	QQQ	ETF	34.92	34.98	34.81	34.85	11192293.0
2009-05-05 10:30:00	QQQ	ETF	34.86	34.86	34.65	34.6522	7523748.0
2009-05-05 11:00:00	QQQ	ETF	34.66	34.79	34.65	34.7601	9127674.0
2009-05-05 11:30:00	QQQ	ETF	34.76	34.87	34.7599	34.8	3881281.0
2009-05-05 12:00:00	QQQ	ETF	34.81	34.86	34.79	34.84	3048909.0
2009-05-05 12:30:00	QQQ	ETF	34.8476	34.86	34.73	34.77	2709599.0
2009-05-05 13:00:00	QQQ	ETF	34.77	34.86	34.7	34.73	3600602.0

> showing 50 of 7,317 rows — these rows as CSV

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