PREVIEW / etf_30min / 2009-05-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-06.parquet
  size:    227 KB
  rows:    7,569

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-06 04:00:00	SPY	ETF	90.12	90.38	90.12	90.38	2100.0
2009-05-06 04:30:00	SPY	ETF	90.33	90.34	90.27	90.34	2000.0
2009-05-06 05:00:00	SPY	ETF	90.46	90.52	90.39	90.39	1330.0
2009-05-06 05:30:00	SPY	ETF	90.49	90.49	90.4	90.4	10800.0
2009-05-06 06:00:00	SPY	ETF	90.4	90.4	90.2	90.25	1900.0
2009-05-06 06:30:00	SPY	ETF	90.2	90.29	90.1	90.29	37430.0
2009-05-06 07:00:00	SPY	ETF	90.29	90.35	89.96	90.06	255512.0
2009-05-06 07:30:00	SPY	ETF	90.08	90.3	89.97	90.24	814259.0
2009-05-06 08:00:00	SPY	ETF	90.24	91.45	89.6	91.21	6077402.0
2009-05-06 08:30:00	SPY	ETF	91.21	91.64	91.2	91.44	4455506.0
2009-05-06 09:00:00	SPY	ETF	91.45	91.71	91.45	91.69	2243317.0
2009-05-06 09:30:00	SPY	ETF	91.68	91.74	91.26	91.55	28362817.0
2009-05-06 10:00:00	SPY	ETF	91.5462	91.63	90.63	90.64	26392101.0
2009-05-06 10:30:00	SPY	ETF	90.64	91.125	90.61	91.09	22340370.0
2009-05-06 11:00:00	SPY	ETF	91.09	91.18	90.72	90.84	17241551.0
2009-05-06 11:30:00	SPY	ETF	90.84	91.28	90.75	91.28	10758982.0
2009-05-06 12:00:00	SPY	ETF	91.28	91.59	91.2	91.565	13921666.0
2009-05-06 12:30:00	SPY	ETF	91.56	91.58	91.0	91.219	9227096.0
2009-05-06 13:00:00	SPY	ETF	91.21	91.3	90.91	90.985	14759426.0
2009-05-06 13:30:00	SPY	ETF	90.98	91.76	90.9	91.73	21046713.0
2009-05-06 14:00:00	SPY	ETF	91.74	92.055	91.16	92.03	18854051.0
2009-05-06 14:30:00	SPY	ETF	92.025	92.2	91.85	91.96	19140293.0
2009-05-06 15:00:00	SPY	ETF	91.96	92.11	91.26	91.53	23875536.0
2009-05-06 15:30:00	SPY	ETF	91.54	92.16	91.35	92.14	40991798.0
2009-05-06 16:00:00	SPY	ETF	92.14	92.27	89.8757	92.2	6667947.0
2009-05-06 16:30:00	SPY	ETF	92.19	92.21	91.92	91.92	1877407.0
2009-05-06 17:00:00	SPY	ETF	91.95	92.06	91.94	92.03	1096747.0
2009-05-06 17:30:00	SPY	ETF	92.03	92.17	92.03	92.16	249170.0
2009-05-06 18:00:00	SPY	ETF	92.16	92.24	92.11	92.14	301388.0
2009-05-06 18:30:00	SPY	ETF	92.15	92.22	92.08	92.15	23763.0
2009-05-06 19:00:00	SPY	ETF	92.18	92.21	92.12	92.13	13201.0
2009-05-06 19:30:00	SPY	ETF	92.15	92.17	92.01	92.04	115410.0
2009-05-06 04:30:00	QQQ	ETF	34.98	34.98	34.98	34.98	100.0
2009-05-06 05:00:00	QQQ	ETF	35.02	35.02	35.01	35.01	700.0
2009-05-06 05:30:00	QQQ	ETF	35.05	35.05	34.98	34.98	5300.0
2009-05-06 06:00:00	QQQ	ETF	34.96	34.98	34.94	34.98	1270.0
2009-05-06 06:30:00	QQQ	ETF	34.91	34.96	34.91	34.96	1470.0
2009-05-06 07:00:00	QQQ	ETF	35.0	35.02	34.86	34.86	49957.0
2009-05-06 07:30:00	QQQ	ETF	34.87	35.0	34.86	35.0	504727.0
2009-05-06 08:00:00	QQQ	ETF	35.01	35.27	34.72	35.2	3251219.0
2009-05-06 08:30:00	QQQ	ETF	35.19	35.32	35.0295	35.24	3544078.0
2009-05-06 09:00:00	QQQ	ETF	35.24	35.34	35.23	35.32	958778.0
2009-05-06 09:30:00	QQQ	ETF	35.32	35.34	35.05	35.15	12714845.0
2009-05-06 10:00:00	QQQ	ETF	35.16	35.17	34.52	34.52	19790954.0
2009-05-06 10:30:00	QQQ	ETF	34.52	34.735	34.46	34.725	13819761.0
2009-05-06 11:00:00	QQQ	ETF	34.72	34.76	34.59	34.67	9440264.0
2009-05-06 11:30:00	QQQ	ETF	34.67	34.89	34.63	34.89	5998407.0
2009-05-06 12:00:00	QQQ	ETF	34.8899	35.0	34.85	34.96	8242009.0
2009-05-06 12:30:00	QQQ	ETF	34.97	34.97	34.74	34.76	7300855.0
2009-05-06 13:00:00	QQQ	ETF	34.77	34.81	34.65	34.67	12614444.0

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

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