PREVIEW / etf_30min / 2009-01-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-06.parquet
  size:    205 KB
  rows:    6,697

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-01-06 04:00:00	SPY	ETF	93.08	93.23	93.06	93.21	12100.0
2009-01-06 04:30:00	SPY	ETF	93.24	93.55	93.24	93.52	1760.0
2009-01-06 05:00:00	SPY	ETF	93.45	93.61	93.43	93.61	1310.0
2009-01-06 05:30:00	SPY	ETF	93.61	93.66	93.61	93.64	800.0
2009-01-06 06:00:00	SPY	ETF	93.73	93.75	93.66	93.68	10920.0
2009-01-06 06:30:00	SPY	ETF	93.65	93.68	93.58	93.58	14630.0
2009-01-06 07:00:00	SPY	ETF	93.65	93.66	93.45	93.55	278720.0
2009-01-06 07:30:00	SPY	ETF	93.6	93.85	93.56	93.77	436398.0
2009-01-06 08:00:00	SPY	ETF	93.76	93.85	93.62	93.7	776077.0
2009-01-06 08:30:00	SPY	ETF	93.71	93.83	93.67	93.75	771737.0
2009-01-06 09:00:00	SPY	ETF	93.74	93.76	93.58	93.64	1301171.0
2009-01-06 09:30:00	SPY	ETF	93.64	94.35	93.45	94.21	33386088.0
2009-01-06 10:00:00	SPY	ETF	94.2	94.45	92.85	92.99	37761404.0
2009-01-06 10:30:00	SPY	ETF	92.99	93.48	92.96	93.08	17085075.0
2009-01-06 11:00:00	SPY	ETF	93.07	93.15	92.68	93.0197	17961923.0
2009-01-06 11:30:00	SPY	ETF	93.02	93.31	93.02	93.15	9729397.0
2009-01-06 12:00:00	SPY	ETF	93.16	93.51	93.05	93.23	9375699.0
2009-01-06 12:30:00	SPY	ETF	93.23	93.71	92.9	93.6	12736021.0
2009-01-06 13:00:00	SPY	ETF	93.59	93.6	92.89	93.14	15017847.0
2009-01-06 13:30:00	SPY	ETF	93.14	93.53	92.95	93.23	16937755.0
2009-01-06 14:00:00	SPY	ETF	93.24	93.86	92.94	93.7548	28467990.0
2009-01-06 14:30:00	SPY	ETF	93.75	94.18	92.7105	94.15	21682674.0
2009-01-06 15:00:00	SPY	ETF	94.16	94.21	93.0975	93.29	26549924.0
2009-01-06 15:30:00	SPY	ETF	93.28	93.54	92.88	93.44	44786857.0
2009-01-06 16:00:00	SPY	ETF	93.48	93.6	93.3	93.31	10015171.0
2009-01-06 16:30:00	SPY	ETF	93.3	93.37	92.9	93.03	3995801.0
2009-01-06 17:00:00	SPY	ETF	93.04	93.1	93.0	93.1	25309.0
2009-01-06 17:30:00	SPY	ETF	93.07	93.17	92.85	93.08	131982.0
2009-01-06 18:00:00	SPY	ETF	93.08	93.09	92.98	93.0	162757.0
2009-01-06 18:30:00	SPY	ETF	92.99	93.1	92.96	93.02	73925.0
2009-01-06 19:00:00	SPY	ETF	93.03	93.11	93.01	93.11	42919.0
2009-01-06 19:30:00	SPY	ETF	93.14	93.39	93.12	93.39	80582.0
2009-01-06 04:00:00	QQQ	ETF	31.13	31.13	31.13	31.13	100.0
2009-01-06 04:30:00	QQQ	ETF	31.24	31.25	31.24	31.25	10000.0
2009-01-06 05:30:00	QQQ	ETF	31.28	31.35	31.28	31.35	1200.0
2009-01-06 06:00:00	QQQ	ETF	31.36	31.36	31.36	31.36	200.0
2009-01-06 06:30:00	QQQ	ETF	31.37	31.38	31.35	31.35	26626.0
2009-01-06 07:00:00	QQQ	ETF	31.37	31.37	31.28	31.31	144293.0
2009-01-06 07:30:00	QQQ	ETF	31.31	31.39	31.29	31.35	137796.0
2009-01-06 08:00:00	QQQ	ETF	31.35	31.45	31.29	31.42	501273.0
2009-01-06 08:30:00	QQQ	ETF	31.43	31.48	31.38	31.42	709794.0
2009-01-06 09:00:00	QQQ	ETF	31.42	31.43	31.27	31.28	585055.0
2009-01-06 09:30:00	QQQ	ETF	31.28	31.57	31.2	31.5	17074530.0
2009-01-06 10:00:00	QQQ	ETF	31.5	31.58	31.17	31.22	18315213.0
2009-01-06 10:30:00	QQQ	ETF	31.23	31.37	31.21	31.24	8165332.0
2009-01-06 11:00:00	QQQ	ETF	31.24	31.26	31.11	31.19	8444034.0
2009-01-06 11:30:00	QQQ	ETF	31.19	31.32	31.1801	31.27	3833283.0
2009-01-06 12:00:00	QQQ	ETF	31.2701	31.43	31.24	31.36	3965724.0
2009-01-06 12:30:00	QQQ	ETF	31.352	31.55	31.35	31.52	4563208.0
2009-01-06 13:00:00	QQQ	ETF	31.52	31.52	31.25	31.35	8634100.0

> showing 50 of 6,697 rows — these rows as CSV

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