PREVIEW / etf_30min / 2010-11-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-29.parquet
  size:    269 KB
  rows:    8,969

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
2010-11-29 04:00:00	SPY	ETF	119.55	119.78	119.55	119.78	26125.0
2010-11-29 04:30:00	SPY	ETF	119.74	119.76	119.3	119.46	17300.0
2010-11-29 05:00:00	SPY	ETF	119.35	119.35	119.0	119.26	3900.0
2010-11-29 05:30:00	SPY	ETF	119.14	119.21	118.91	119.07	4300.0
2010-11-29 06:00:00	SPY	ETF	119.03	119.03	118.88	118.88	13300.0
2010-11-29 06:30:00	SPY	ETF	119.0	119.3	119.0	119.21	126000.0
2010-11-29 07:00:00	SPY	ETF	119.22	119.24	118.8	118.87	292350.0
2010-11-29 07:30:00	SPY	ETF	118.85	118.85	118.48	118.71	617526.0
2010-11-29 08:00:00	SPY	ETF	118.72	119.68	118.57	118.82	1317373.0
2010-11-29 08:30:00	SPY	ETF	118.8	118.84	118.54	118.55	1473320.0
2010-11-29 09:00:00	SPY	ETF	118.55	118.81	118.3	118.52	1909170.0
2010-11-29 09:30:00	SPY	ETF	118.5	118.75	117.85	118.02	27878796.0
2010-11-29 10:00:00	SPY	ETF	118.02	118.23	117.74	118.01	24810869.0
2010-11-29 10:30:00	SPY	ETF	118.02	118.5	118.0	118.15	20306667.0
2010-11-29 11:00:00	SPY	ETF	118.15	118.43	118.07	118.29	13479778.0
2010-11-29 11:30:00	SPY	ETF	118.29	118.37	117.89	118.08	14097360.0
2010-11-29 12:00:00	SPY	ETF	118.05	118.44	118.03	118.328	9684493.0
2010-11-29 12:30:00	SPY	ETF	118.32	118.45	118.25	118.38	10456857.0
2010-11-29 13:00:00	SPY	ETF	118.38	118.39	118.1	118.18	6187553.0
2010-11-29 13:30:00	SPY	ETF	118.18	118.34	118.05	118.25	13386345.0
2010-11-29 14:00:00	SPY	ETF	118.25	119.3513	118.22	118.62	14589776.0
2010-11-29 14:30:00	SPY	ETF	118.62	119.15	118.61	119.1074	17051033.0
2010-11-29 15:00:00	SPY	ETF	119.11	119.4	119.1	119.36	12454655.0
2010-11-29 15:30:00	SPY	ETF	119.36	119.48	119.16	119.17	18175194.0
2010-11-29 16:00:00	SPY	ETF	119.17	119.3513	118.1	119.14	9214769.0
2010-11-29 16:30:00	SPY	ETF	119.14	119.23	118.4773	119.22	2387467.0
2010-11-29 17:00:00	SPY	ETF	119.23	119.24	119.16	119.18	1135951.0
2010-11-29 17:30:00	SPY	ETF	119.22	119.22	119.15	119.21	17510.0
2010-11-29 18:00:00	SPY	ETF	119.2	119.22	119.15	119.21	61662.0
2010-11-29 18:30:00	SPY	ETF	119.2	119.21	119.1	119.1	23822.0
2010-11-29 19:00:00	SPY	ETF	119.1	119.13	119.07	119.08	12678.0
2010-11-29 19:30:00	SPY	ETF	119.1	119.27	119.1	119.21	102338.0
2010-11-29 04:00:00	QQQ	ETF	52.91	53.05	52.91	53.05	3100.0
2010-11-29 04:30:00	QQQ	ETF	53.08	53.08	52.95	52.95	2400.0
2010-11-29 05:00:00	QQQ	ETF	52.83	52.89	52.8	52.89	4100.0
2010-11-29 05:30:00	QQQ	ETF	52.8	52.8	52.8	52.8	200.0
2010-11-29 06:00:00	QQQ	ETF	52.79	52.79	52.74	52.79	2400.0
2010-11-29 06:30:00	QQQ	ETF	52.81	52.89	52.81	52.88	2800.0
2010-11-29 07:00:00	QQQ	ETF	52.84	52.84	52.68	52.74	99350.0
2010-11-29 07:30:00	QQQ	ETF	52.7	52.7	52.57	52.62	32760.0
2010-11-29 08:00:00	QQQ	ETF	52.65	52.76	52.62	52.74	439195.0
2010-11-29 08:30:00	QQQ	ETF	52.74	52.75	52.69	52.71	438951.0
2010-11-29 09:00:00	QQQ	ETF	52.7	52.74	52.63	52.69	388032.0
2010-11-29 09:30:00	QQQ	ETF	52.69	52.8	52.19	52.2601	11241406.0
2010-11-29 10:00:00	QQQ	ETF	52.27	52.34	52.1	52.23	6140610.0
2010-11-29 10:30:00	QQQ	ETF	52.23	52.45	52.19	52.23	5352610.0
2010-11-29 11:00:00	QQQ	ETF	52.24	52.3864	52.185	52.29	5998323.0
2010-11-29 11:30:00	QQQ	ETF	52.285	52.32	52.13	52.17	2441920.0
2010-11-29 12:00:00	QQQ	ETF	52.17	52.35	52.15	52.31	3137798.0
2010-11-29 12:30:00	QQQ	ETF	52.31	52.365	52.27	52.3099	2282161.0

> showing 50 of 8,969 rows — these rows as CSV

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