PREVIEW / etf_30min / 2009-06-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-24.parquet
  size:    218 KB
  rows:    7,168

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-06-24 04:00:00	SPY	ETF	89.62	89.68	89.62	89.68	1050.0
2009-06-24 04:30:00	SPY	ETF	89.74	89.74	89.62	89.62	20600.0
2009-06-24 05:00:00	SPY	ETF	89.78	89.87	89.75	89.75	20500.0
2009-06-24 05:30:00	SPY	ETF	89.94	89.94	89.94	89.94	800.0
2009-06-24 06:00:00	SPY	ETF	89.83	89.9	89.81	89.9	1000.0
2009-06-24 06:30:00	SPY	ETF	89.87	89.87	89.74	89.84	24425.0
2009-06-24 07:00:00	SPY	ETF	89.84	90.09	89.8	89.91	256600.0
2009-06-24 07:30:00	SPY	ETF	89.91	89.94	89.76	89.91	233445.0
2009-06-24 08:00:00	SPY	ETF	89.9	89.96	89.81	89.92	1731796.0
2009-06-24 08:30:00	SPY	ETF	89.96	90.44	89.36	90.26	4711500.0
2009-06-24 09:00:00	SPY	ETF	90.26	90.3	90.1	90.15	1131886.0
2009-06-24 09:30:00	SPY	ETF	90.16	90.45	90.04	90.44	14142896.0
2009-06-24 10:00:00	SPY	ETF	90.44	90.93	90.25	90.8	20756443.0
2009-06-24 10:30:00	SPY	ETF	90.81	91.07	90.71	90.95	12563408.0
2009-06-24 11:00:00	SPY	ETF	90.95	91.08	90.83	90.96	8357192.0
2009-06-24 11:30:00	SPY	ETF	90.96	90.99	90.73	90.81	6297801.0
2009-06-24 12:00:00	SPY	ETF	90.81	90.86	90.63	90.7	4363796.0
2009-06-24 12:30:00	SPY	ETF	90.7	90.85	90.57	90.66	5582208.0
2009-06-24 13:00:00	SPY	ETF	90.67	90.87	90.655	90.81	4386547.0
2009-06-24 13:30:00	SPY	ETF	90.81	90.83	90.59	90.668	5640459.0
2009-06-24 14:00:00	SPY	ETF	90.66	90.88	90.21	90.331	23517270.0
2009-06-24 14:30:00	SPY	ETF	90.33	90.39	89.82	90.14	26805431.0
2009-06-24 15:00:00	SPY	ETF	90.14	90.26	89.6	89.94	28179588.0
2009-06-24 15:30:00	SPY	ETF	89.95	90.18	89.65	90.11	31389215.0
2009-06-24 16:00:00	SPY	ETF	90.1	90.28	89.65	90.2	6326920.0
2009-06-24 16:30:00	SPY	ETF	90.2	90.37	90.17	90.22	1305723.0
2009-06-24 17:00:00	SPY	ETF	90.21	90.24	89.5001	90.16	1106946.0
2009-06-24 17:30:00	SPY	ETF	90.15	90.19	90.14	90.16	20725.0
2009-06-24 18:00:00	SPY	ETF	90.16	90.23	90.15	90.18	25695.0
2009-06-24 18:30:00	SPY	ETF	90.18	90.23	90.18	90.2	5367.0
2009-06-24 19:00:00	SPY	ETF	90.21	90.21	90.18	90.2	8100.0
2009-06-24 19:30:00	SPY	ETF	90.2	90.22	90.19	90.2	35115.0
2009-06-24 05:30:00	QQQ	ETF	35.2	35.2	35.19	35.19	300.0
2009-06-24 06:00:00	QQQ	ETF	35.15	35.15	35.15	35.15	100.0
2009-06-24 06:30:00	QQQ	ETF	35.17	35.17	35.16	35.17	40600.0
2009-06-24 07:00:00	QQQ	ETF	35.19	35.27	35.17	35.27	23300.0
2009-06-24 07:30:00	QQQ	ETF	35.22	35.23	35.17	35.2	86850.0
2009-06-24 08:00:00	QQQ	ETF	35.18	35.21	35.16	35.19	138225.0
2009-06-24 08:30:00	QQQ	ETF	35.19	35.38	35.19	35.35	810019.0
2009-06-24 09:00:00	QQQ	ETF	35.34	35.35	35.29	35.3	235349.0
2009-06-24 09:30:00	QQQ	ETF	35.3	35.5	35.28	35.49	9179234.0
2009-06-24 10:00:00	QQQ	ETF	35.48	35.79	35.42	35.74	12635857.0
2009-06-24 10:30:00	QQQ	ETF	35.74	35.87	35.68	35.78	7270287.0
2009-06-24 11:00:00	QQQ	ETF	35.78	35.84	35.74	35.79	4167245.0
2009-06-24 11:30:00	QQQ	ETF	35.8	35.81	35.7499	35.78	3691723.0
2009-06-24 12:00:00	QQQ	ETF	35.79	35.81	35.7	35.74	3483241.0
2009-06-24 12:30:00	QQQ	ETF	35.74	35.77	35.69	35.75	2936781.0
2009-06-24 13:00:00	QQQ	ETF	35.7501	35.81	35.74	35.78	1712068.0
2009-06-24 13:30:00	QQQ	ETF	35.77	35.78	35.67	35.692	2666740.0
2009-06-24 14:00:00	QQQ	ETF	35.69	35.8099	35.54	35.6	10977086.0

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

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