PREVIEW / etf_30min / 2009-02-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-25.parquet
  size:    205 KB
  rows:    6,822

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-02-25 04:00:00	SPY	ETF	77.05	77.14	77.03	77.03	3900.0
2009-02-25 05:00:00	SPY	ETF	77.54	77.54	77.51	77.51	1500.0
2009-02-25 06:00:00	SPY	ETF	77.4	77.61	77.38	77.38	7200.0
2009-02-25 06:30:00	SPY	ETF	77.35	77.35	76.81	76.96	33600.0
2009-02-25 07:00:00	SPY	ETF	76.91	77.14	76.79	77.0	181501.0
2009-02-25 07:30:00	SPY	ETF	76.98	77.29	76.98	77.21	344963.0
2009-02-25 08:00:00	SPY	ETF	77.19	77.54	76.78	77.19	1108285.0
2009-02-25 08:30:00	SPY	ETF	77.18	77.28	76.84	77.02	1250976.0
2009-02-25 09:00:00	SPY	ETF	77.0	77.27	76.9	77.16	2481399.0
2009-02-25 09:30:00	SPY	ETF	77.14	77.36	76.43	76.59	35146337.0
2009-02-25 10:00:00	SPY	ETF	76.67	76.67	75.77	76.36	49008819.0
2009-02-25 10:30:00	SPY	ETF	76.37	76.42	75.63	75.87	31324692.0
2009-02-25 11:00:00	SPY	ETF	75.87	76.53	75.83	76.45	23725754.0
2009-02-25 11:30:00	SPY	ETF	76.46	77.02	76.0599	76.33	35702887.0
2009-02-25 12:00:00	SPY	ETF	76.33	76.52	75.96	76.04	20174263.0
2009-02-25 12:30:00	SPY	ETF	76.04	76.24	75.75	76.11	22377245.0
2009-02-25 13:00:00	SPY	ETF	76.11	76.52	76.04	76.18	19714435.0
2009-02-25 13:30:00	SPY	ETF	76.18	77.57	76.18	77.4	27842376.0
2009-02-25 14:00:00	SPY	ETF	77.39	77.52	76.23	76.93	55452368.0
2009-02-25 14:30:00	SPY	ETF	76.93	77.54	76.62	77.23	33470682.0
2009-02-25 15:00:00	SPY	ETF	77.23	78.42	77.12	78.2	39075560.0
2009-02-25 15:30:00	SPY	ETF	78.19	78.35	76.79	76.85	48438376.0
2009-02-25 16:00:00	SPY	ETF	76.86	78.1	76.1	76.64	8911601.0
2009-02-25 16:30:00	SPY	ETF	76.61	78.2779	76.6	76.63	1735822.0
2009-02-25 17:00:00	SPY	ETF	76.61	77.6978	76.58	76.91	3767523.0
2009-02-25 17:30:00	SPY	ETF	76.85	76.85	76.75	76.85	55119.0
2009-02-25 18:00:00	SPY	ETF	76.88	76.95	76.8	76.84	102546.0
2009-02-25 18:30:00	SPY	ETF	76.8	76.87	76.78	76.83	21889.0
2009-02-25 19:00:00	SPY	ETF	76.87	77.25	76.87	77.25	69977.0
2009-02-25 19:30:00	SPY	ETF	77.22	77.35	77.19	77.35	104271.0
2009-02-25 06:30:00	QQQ	ETF	28.6	28.6	28.53	28.53	800.0
2009-02-25 07:00:00	QQQ	ETF	28.51	28.55	28.47	28.54	40265.0
2009-02-25 07:30:00	QQQ	ETF	28.57	28.63	28.53	28.62	257788.0
2009-02-25 08:00:00	QQQ	ETF	28.62	28.77	28.6	28.7	691857.0
2009-02-25 08:30:00	QQQ	ETF	28.68	28.7	28.57	28.59	530520.0
2009-02-25 09:00:00	QQQ	ETF	28.61	28.69	28.57	28.63	1081765.0
2009-02-25 09:30:00	QQQ	ETF	28.62	28.68	28.49	28.55	24108004.0
2009-02-25 10:00:00	QQQ	ETF	28.54	28.56	28.24	28.48	25908690.0
2009-02-25 10:30:00	QQQ	ETF	28.48	28.49	28.14	28.27	17901238.0
2009-02-25 11:00:00	QQQ	ETF	28.2795	28.48	28.26	28.45	8261736.0
2009-02-25 11:30:00	QQQ	ETF	28.46	28.65	28.33	28.36	13931573.0
2009-02-25 12:00:00	QQQ	ETF	28.36	28.438	28.27	28.3	7469279.0
2009-02-25 12:30:00	QQQ	ETF	28.299	28.39	28.24	28.38	7365884.0
2009-02-25 13:00:00	QQQ	ETF	28.37	28.53	28.35	28.4	11193563.0
2009-02-25 13:30:00	QQQ	ETF	28.39	28.8	28.39	28.745	11623864.0
2009-02-25 14:00:00	QQQ	ETF	28.74	28.8	28.43	28.68	19632383.0
2009-02-25 14:30:00	QQQ	ETF	28.68	28.79	28.58	28.69	15477603.0
2009-02-25 15:00:00	QQQ	ETF	28.68	29.13	28.64	29.07	18441710.0
2009-02-25 15:30:00	QQQ	ETF	29.06	29.17	28.58	28.59	26140331.0
2009-02-25 16:00:00	QQQ	ETF	28.59	28.61	28.41	28.48	3972951.0

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

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