PREVIEW / etf_30min / 2008-07-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-14.parquet
  size:    177 KB
  rows:    6,017

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
2008-07-14 04:00:00	SPY	ETF	125.11	125.16	125.09	125.14	600.0
2008-07-14 04:30:00	SPY	ETF	124.82	124.82	124.77	124.77	200.0
2008-07-14 05:00:00	SPY	ETF	124.68	124.7	124.64	124.7	2800.0
2008-07-14 05:30:00	SPY	ETF	124.82	125.0	124.82	125.0	5100.0
2008-07-14 06:00:00	SPY	ETF	124.98	125.27	124.98	125.27	36200.0
2008-07-14 06:30:00	SPY	ETF	125.33	125.5	125.31	125.5	81500.0
2008-07-14 07:00:00	SPY	ETF	125.45	125.92	125.45	125.68	1122542.0
2008-07-14 07:30:00	SPY	ETF	125.68	125.68	125.41	125.47	952069.0
2008-07-14 08:00:00	SPY	ETF	125.49	125.83	125.44	125.55	1952324.0
2008-07-14 08:30:00	SPY	ETF	125.55	125.56	125.39	125.41	1091105.0
2008-07-14 09:00:00	SPY	ETF	125.42	125.53	124.82	125.26	3650361.0
2008-07-14 09:30:00	SPY	ETF	125.26	125.5	124.23	124.25	41261672.0
2008-07-14 10:00:00	SPY	ETF	124.24	124.8392	123.71	123.94	37046228.0
2008-07-14 10:30:00	SPY	ETF	123.94	124.345	123.67	124.29	18823682.0
2008-07-14 11:00:00	SPY	ETF	124.28	124.38	123.49	123.72	17443641.0
2008-07-14 11:30:00	SPY	ETF	123.71	123.795	122.5	123.03	24273682.0
2008-07-14 12:00:00	SPY	ETF	123.03	123.2	122.71	122.94	20045635.0
2008-07-14 12:30:00	SPY	ETF	122.95	123.16	122.58	122.88	12442531.0
2008-07-14 13:00:00	SPY	ETF	122.89	122.93	122.4	122.83	15778015.0
2008-07-14 13:30:00	SPY	ETF	122.82	123.9266	122.64	123.1	18747891.0
2008-07-14 14:00:00	SPY	ETF	123.1	123.9266	122.97	123.21	15245624.0
2008-07-14 14:30:00	SPY	ETF	123.2	123.42	122.69	122.88	15766224.0
2008-07-14 15:00:00	SPY	ETF	122.87	123.51	122.54	123.36	19060654.0
2008-07-14 15:30:00	SPY	ETF	123.35	123.79	122.51	122.82	42234709.0
2008-07-14 16:00:00	SPY	ETF	122.83	123.2941	122.51	122.75	3845032.0
2008-07-14 16:30:00	SPY	ETF	122.78	122.98	122.68	122.81	1512832.0
2008-07-14 17:00:00	SPY	ETF	122.8	122.86	122.64	122.74	189099.0
2008-07-14 17:30:00	SPY	ETF	122.73	122.75	122.67	122.73	21300.0
2008-07-14 18:00:00	SPY	ETF	122.76	122.84	122.73	122.83	38122.0
2008-07-14 18:30:00	SPY	ETF	122.83	122.86	122.74	122.79	29534.0
2008-07-14 19:00:00	SPY	ETF	122.76	122.76	122.71	122.74	9984.0
2008-07-14 19:30:00	SPY	ETF	122.74	122.81	122.74	122.8	56302.0
2008-07-14 04:00:00	QQQ	ETF	45.03	45.1	45.03	45.1	300.0
2008-07-14 04:30:00	QQQ	ETF	44.97	44.97	44.97	44.97	100.0
2008-07-14 05:00:00	QQQ	ETF	44.92	44.92	44.92	44.92	200.0
2008-07-14 05:30:00	QQQ	ETF	44.93	44.93	44.93	44.93	100.0
2008-07-14 06:00:00	QQQ	ETF	45.08	45.1	45.07	45.1	11500.0
2008-07-14 06:30:00	QQQ	ETF	45.14	45.27	45.14	45.27	170250.0
2008-07-14 07:00:00	QQQ	ETF	45.25	45.38	45.25	45.34	234090.0
2008-07-14 07:30:00	QQQ	ETF	45.27	45.27	45.19	45.22	152628.0
2008-07-14 08:00:00	QQQ	ETF	45.22	45.25	45.17	45.18	555344.0
2008-07-14 08:30:00	QQQ	ETF	45.18	45.2	45.06	45.17	982801.0
2008-07-14 09:00:00	QQQ	ETF	45.18	45.19	45.11	45.14	1257419.0
2008-07-14 09:30:00	QQQ	ETF	45.13	45.18	44.67	44.69	20904203.0
2008-07-14 10:00:00	QQQ	ETF	44.68	44.85	44.38	44.48	23741750.0
2008-07-14 10:30:00	QQQ	ETF	44.48	44.78	44.35	44.7	12976009.0
2008-07-14 11:00:00	QQQ	ETF	44.7	44.75	44.38	44.53	10485052.0
2008-07-14 11:30:00	QQQ	ETF	44.53	44.58	44.12	44.34	11790762.0
2008-07-14 12:00:00	QQQ	ETF	44.34	44.3685	44.17	44.25	9901874.0
2008-07-14 12:30:00	QQQ	ETF	44.25	44.35	44.13	44.25	6772736.0

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

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