PREVIEW / etf_30min / 2007-03-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-29.parquet
  size:    105 KB
  rows:    3,554

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
2007-03-29 06:30:00	SPY	ETF	142.19	142.2	142.13	142.13	90400.0
2007-03-29 07:00:00	SPY	ETF	142.19	142.19	142.09	142.09	27500.0
2007-03-29 07:30:00	SPY	ETF	142.08	142.23	142.08	142.2	94100.0
2007-03-29 08:00:00	SPY	ETF	142.2	142.33	142.1	142.22	653200.0
2007-03-29 08:30:00	SPY	ETF	142.21	142.68	142.21	142.53	4136800.0
2007-03-29 09:00:00	SPY	ETF	142.56	142.59	142.48	142.55	1138600.0
2007-03-29 09:30:00	SPY	ETF	142.54	142.61	142.2	142.24	10307218.0
2007-03-29 10:00:00	SPY	ETF	142.24	142.5	142.2	142.38	7922550.0
2007-03-29 10:30:00	SPY	ETF	142.38	142.42	141.89	141.91	9162945.0
2007-03-29 11:00:00	SPY	ETF	141.91	142.29	141.91	142.26	7120238.0
2007-03-29 11:30:00	SPY	ETF	142.26	142.3	141.61	141.61	12780750.0
2007-03-29 12:00:00	SPY	ETF	141.62	142.02	141.6	141.75	9901428.0
2007-03-29 12:30:00	SPY	ETF	141.76	142.0	141.61	141.81	9262650.0
2007-03-29 13:00:00	SPY	ETF	141.81	141.91	141.43	141.62	9351949.0
2007-03-29 13:30:00	SPY	ETF	141.62	141.79	141.39	141.47	5663702.0
2007-03-29 14:00:00	SPY	ETF	141.47	141.52	141.19	141.45	11862000.0
2007-03-29 14:30:00	SPY	ETF	141.45	141.7	141.23	141.7	12600297.0
2007-03-29 15:00:00	SPY	ETF	141.69	142.02	141.62	141.93	9689799.0
2007-03-29 15:30:00	SPY	ETF	141.93	142.27	141.92	142.12	11901021.0
2007-03-29 16:00:00	SPY	ETF	142.13	142.22	141.9	142.0	2911600.0
2007-03-29 16:30:00	SPY	ETF	142.0	142.15	141.99	142.09	288200.0
2007-03-29 17:00:00	SPY	ETF	142.11	142.2246	142.08	142.11	58100.0
2007-03-29 17:30:00	SPY	ETF	142.09	142.1	142.07	142.1	31000.0
2007-03-29 18:00:00	SPY	ETF	142.11	142.12	142.07	142.07	39100.0
2007-03-29 18:30:00	SPY	ETF	142.1	142.12	142.1	142.12	1700.0
2007-03-29 19:30:00	SPY	ETF	142.12	142.19	142.12	142.18	24000.0
2007-03-29 05:00:00	QQQ	ETF	43.72	43.72	43.72	43.72	600.0
2007-03-29 07:00:00	QQQ	ETF	43.69	43.71	43.67	43.68	26400.0
2007-03-29 07:30:00	QQQ	ETF	43.68	43.7	43.67	43.7	31800.0
2007-03-29 08:00:00	QQQ	ETF	43.69	43.74	43.68	43.74	954175.0
2007-03-29 08:30:00	QQQ	ETF	43.74	43.86	43.74	43.83	2203001.0
2007-03-29 09:00:00	QQQ	ETF	43.83	43.84	43.8	43.84	523800.0
2007-03-29 09:30:00	QQQ	ETF	43.84	43.85	43.66	43.69	8987400.0
2007-03-29 10:00:00	QQQ	ETF	43.69	43.77	43.65	43.73	7782400.0
2007-03-29 10:30:00	QQQ	ETF	43.73	43.75	43.48	43.51	10623600.0
2007-03-29 11:00:00	QQQ	ETF	43.52	43.6	43.46	43.57	7491100.0
2007-03-29 11:30:00	QQQ	ETF	43.56	43.6	43.33	43.33	7901600.0
2007-03-29 12:00:00	QQQ	ETF	43.33	43.41	43.31	43.33	7491800.0
2007-03-29 12:30:00	QQQ	ETF	43.33	43.38	43.27	43.33	5594300.0
2007-03-29 13:00:00	QQQ	ETF	43.32	43.41	43.22	43.31	8621200.0
2007-03-29 13:30:00	QQQ	ETF	43.31	43.34	43.19	43.23	5984300.0
2007-03-29 14:00:00	QQQ	ETF	43.22	43.24	43.1	43.21	10790500.0
2007-03-29 14:30:00	QQQ	ETF	43.21	43.33	43.13	43.31	9094000.0
2007-03-29 15:00:00	QQQ	ETF	43.31	43.44	43.24	43.42	9866000.0
2007-03-29 15:30:00	QQQ	ETF	43.41	43.58	43.4	43.58	13381600.0
2007-03-29 16:00:00	QQQ	ETF	43.57	43.63	43.5	43.5	4550521.0
2007-03-29 16:30:00	QQQ	ETF	43.5	43.6	43.5	43.59	613791.0
2007-03-29 17:00:00	QQQ	ETF	43.6	43.61	43.57	43.6	200632.0
2007-03-29 17:30:00	QQQ	ETF	43.6	43.6	43.58	43.6	29950.0
2007-03-29 18:00:00	QQQ	ETF	43.6	43.6	43.57	43.59	36400.0

> showing 50 of 3,554 rows — these rows as CSV

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