PREVIEW / etf_30min / 2009-05-29

all etf 30-min files

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

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-29 04:00:00	SPY	ETF	91.24	91.24	91.24	91.24	400.0
2009-05-29 04:30:00	SPY	ETF	91.33	91.33	91.33	91.33	400.0
2009-05-29 05:00:00	SPY	ETF	91.33	91.34	91.33	91.34	700.0
2009-05-29 05:30:00	SPY	ETF	91.24	91.49	91.24	91.49	7118.0
2009-05-29 06:00:00	SPY	ETF	91.48	91.52	91.45	91.45	16100.0
2009-05-29 06:30:00	SPY	ETF	91.41	91.63	91.41	91.63	5000.0
2009-05-29 07:00:00	SPY	ETF	91.6	91.81	91.58	91.75	132446.0
2009-05-29 07:30:00	SPY	ETF	91.74	91.74	91.56	91.57	306596.0
2009-05-29 08:00:00	SPY	ETF	91.55	91.66	91.28	91.58	598984.0
2009-05-29 08:30:00	SPY	ETF	91.58	91.63	91.34	91.39	1735036.0
2009-05-29 09:00:00	SPY	ETF	91.39	91.6	91.38	91.43	1313744.0
2009-05-29 09:30:00	SPY	ETF	91.42	91.68	90.68	91.14	41240371.0
2009-05-29 10:00:00	SPY	ETF	91.14	91.62	90.9	91.53	20151913.0
2009-05-29 10:30:00	SPY	ETF	91.53	91.57	91.05	91.325	15924484.0
2009-05-29 11:00:00	SPY	ETF	91.32	91.4	90.94	90.94	13765905.0
2009-05-29 11:30:00	SPY	ETF	90.97	91.14	90.81	90.89	17461663.0
2009-05-29 12:00:00	SPY	ETF	90.89	91.3	90.885	91.21	7316478.0
2009-05-29 12:30:00	SPY	ETF	91.22	91.255	90.95	91.08	8692429.0
2009-05-29 13:00:00	SPY	ETF	91.08	91.3	91.07	91.27	7027693.0
2009-05-29 13:30:00	SPY	ETF	91.27	91.45	91.24	91.3	7999468.0
2009-05-29 14:00:00	SPY	ETF	91.3	91.45	91.19	91.2588	5666316.0
2009-05-29 14:30:00	SPY	ETF	91.25	91.29	90.81	91.05	13361939.0
2009-05-29 15:00:00	SPY	ETF	91.05	91.36	90.96	91.3	10886429.0
2009-05-29 15:30:00	SPY	ETF	91.3	92.69	91.08	92.65	41070276.0
2009-05-29 16:00:00	SPY	ETF	92.65	93.17	91.0453	92.57	34234279.0
2009-05-29 16:30:00	SPY	ETF	92.57	92.63	92.41	92.55	3964672.0
2009-05-29 17:00:00	SPY	ETF	92.54	92.66	92.48	92.54	2400258.0
2009-05-29 17:30:00	SPY	ETF	92.54	92.6	92.53	92.57	197406.0
2009-05-29 18:00:00	SPY	ETF	92.58	92.6	92.41	92.55	24910.0
2009-05-29 18:30:00	SPY	ETF	92.55	92.55	92.37	92.41	150060.0
2009-05-29 19:00:00	SPY	ETF	92.42	92.42	92.27	92.36	138538.0
2009-05-29 19:30:00	SPY	ETF	92.37	92.47	92.37	92.47	21987.0
2009-05-29 04:00:00	QQQ	ETF	35.06	35.06	35.06	35.06	100.0
2009-05-29 04:30:00	QQQ	ETF	35.06	35.09	35.06	35.09	300.0
2009-05-29 05:00:00	QQQ	ETF	35.09	35.1	35.09	35.1	2000.0
2009-05-29 05:30:00	QQQ	ETF	35.12	35.12	35.12	35.12	1000.0
2009-05-29 06:00:00	QQQ	ETF	35.08	35.09	35.07	35.09	4300.0
2009-05-29 06:30:00	QQQ	ETF	35.13	35.17	35.13	35.17	659.0
2009-05-29 07:00:00	QQQ	ETF	35.17	35.33	35.17	35.21	104822.0
2009-05-29 07:30:00	QQQ	ETF	35.21	35.22	35.15	35.16	111674.0
2009-05-29 08:00:00	QQQ	ETF	35.16	35.17	35.05	35.15	431104.0
2009-05-29 08:30:00	QQQ	ETF	35.13	35.15	34.99	35.0	356726.0
2009-05-29 09:00:00	QQQ	ETF	35.01	35.08	34.98	34.99	278256.0
2009-05-29 09:30:00	QQQ	ETF	34.98	35.25	34.8385	35.03	24326100.0
2009-05-29 10:00:00	QQQ	ETF	35.02	35.14	34.94	35.13	8667860.0
2009-05-29 10:30:00	QQQ	ETF	35.13	35.14	34.96	35.03	5057868.0
2009-05-29 11:00:00	QQQ	ETF	35.03	35.08	34.83	34.83	7007245.0
2009-05-29 11:30:00	QQQ	ETF	34.82	34.88	34.76	34.79	8242915.0
2009-05-29 12:00:00	QQQ	ETF	34.79	34.94	34.79	34.91	3402592.0
2009-05-29 12:30:00	QQQ	ETF	34.91	34.91	34.81	34.83	5026886.0

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

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