PREVIEW / etf_30min / 2009-07-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-08.parquet
  size:    227 KB
  rows:    7,427

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-07-08 04:00:00	SPY	ETF	88.52	88.52	88.52	88.52	100.0
2009-07-08 04:30:00	SPY	ETF	88.47	88.47	88.4	88.4	500.0
2009-07-08 05:00:00	SPY	ETF	88.46	88.46	88.46	88.46	500.0
2009-07-08 05:30:00	SPY	ETF	88.62	88.67	88.56	88.64	5500.0
2009-07-08 06:00:00	SPY	ETF	88.63	88.69	88.56	88.64	3591.0
2009-07-08 06:30:00	SPY	ETF	88.57	88.57	88.38	88.41	41100.0
2009-07-08 07:00:00	SPY	ETF	88.5	88.7	88.48	88.63	170480.0
2009-07-08 07:30:00	SPY	ETF	88.64	88.64	88.44	88.46	97991.0
2009-07-08 08:00:00	SPY	ETF	88.42	88.43	88.24	88.32	1348455.0
2009-07-08 08:30:00	SPY	ETF	88.33	88.68	88.11	88.34	1371912.0
2009-07-08 09:00:00	SPY	ETF	88.34	88.65	88.34	88.61	2799154.0
2009-07-08 09:30:00	SPY	ETF	88.59	88.72	88.32	88.36	19293515.0
2009-07-08 10:00:00	SPY	ETF	88.36	88.8	88.34	88.585	12931197.0
2009-07-08 10:30:00	SPY	ETF	88.59	88.59	88.15	88.15	17715472.0
2009-07-08 11:00:00	SPY	ETF	88.15	88.16	87.51	87.575	25306461.0
2009-07-08 11:30:00	SPY	ETF	87.59	87.79	87.4	87.54	12623230.0
2009-07-08 12:00:00	SPY	ETF	87.55	87.59	87.1	87.12	14450907.0
2009-07-08 12:30:00	SPY	ETF	87.12	87.41	87.08	87.2705	11756260.0
2009-07-08 13:00:00	SPY	ETF	87.27	87.86	87.26	87.8	17102714.0
2009-07-08 13:30:00	SPY	ETF	87.8	87.86	87.55	87.6	8662677.0
2009-07-08 14:00:00	SPY	ETF	87.61	87.64	87.09	87.2	14043652.0
2009-07-08 14:30:00	SPY	ETF	87.2	87.6	87.0	87.52	16186001.0
2009-07-08 15:00:00	SPY	ETF	87.51	87.77	87.34	87.45	19122965.0
2009-07-08 15:30:00	SPY	ETF	87.45	88.34	87.425	88.01	37769062.0
2009-07-08 16:00:00	SPY	ETF	88.01	88.0512	87.316	87.87	11844746.0
2009-07-08 16:30:00	SPY	ETF	87.85	88.182	87.8445	87.98	1844070.0
2009-07-08 17:00:00	SPY	ETF	87.98	88.08	87.61	88.08	283570.0
2009-07-08 17:30:00	SPY	ETF	88.05	88.08	88.0	88.04	141364.0
2009-07-08 18:00:00	SPY	ETF	88.06	88.09	88.0	88.05	32840.0
2009-07-08 18:30:00	SPY	ETF	88.05	88.12	88.04	88.1	32829.0
2009-07-08 19:00:00	SPY	ETF	88.08	88.08	88.02	88.06	19457.0
2009-07-08 19:30:00	SPY	ETF	88.08	88.08	88.01	88.08	56114.0
2009-07-08 05:00:00	QQQ	ETF	34.69	34.7	34.69	34.7	1100.0
2009-07-08 05:30:00	QQQ	ETF	34.77	34.77	34.76	34.76	1480.0
2009-07-08 06:00:00	QQQ	ETF	34.77	34.77	34.75	34.75	1100.0
2009-07-08 06:30:00	QQQ	ETF	34.71	34.71	34.71	34.71	500.0
2009-07-08 07:00:00	QQQ	ETF	34.73	34.79	34.7	34.79	229078.0
2009-07-08 07:30:00	QQQ	ETF	34.77	34.77	34.71	34.71	183780.0
2009-07-08 08:00:00	QQQ	ETF	34.71	34.71	34.64	34.7	977169.0
2009-07-08 08:30:00	QQQ	ETF	34.69	34.74	34.67	34.73	506307.0
2009-07-08 09:00:00	QQQ	ETF	34.74	34.8	34.72	34.74	816486.0
2009-07-08 09:30:00	QQQ	ETF	34.73	34.84	34.58	34.62	18993481.0
2009-07-08 10:00:00	QQQ	ETF	34.62	34.84	34.62	34.74	12246568.0
2009-07-08 10:30:00	QQQ	ETF	34.74	34.749	34.56	34.5614	10186594.0
2009-07-08 11:00:00	QQQ	ETF	34.56	34.6477	34.33	34.37	14158164.0
2009-07-08 11:30:00	QQQ	ETF	34.37	34.53	34.36	34.44	9519742.0
2009-07-08 12:00:00	QQQ	ETF	34.43	34.47	34.3	34.31	8030879.0
2009-07-08 12:30:00	QQQ	ETF	34.31	34.47	34.3	34.4201	5190477.0
2009-07-08 13:00:00	QQQ	ETF	34.42	34.64	34.42	34.63	8817902.0
2009-07-08 13:30:00	QQQ	ETF	34.63	34.65	34.425	34.531	7097635.0

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

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