PREVIEW / etf_30min / 2009-10-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-30.parquet
  size:    248 KB
  rows:    8,080

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-10-30 04:00:00	SPY	ETF	106.24	106.24	106.08	106.08	2206.0
2009-10-30 04:30:00	SPY	ETF	106.31	106.33	106.31	106.33	500.0
2009-10-30 05:00:00	SPY	ETF	106.38	106.5	106.38	106.5	300.0
2009-10-30 05:30:00	SPY	ETF	106.3	106.3	106.21	106.21	2200.0
2009-10-30 06:00:00	SPY	ETF	106.28	106.28	106.27	106.27	2100.0
2009-10-30 06:30:00	SPY	ETF	106.25	106.25	106.25	106.25	450.0
2009-10-30 07:00:00	SPY	ETF	106.28	106.34	106.23	106.26	115167.0
2009-10-30 07:30:00	SPY	ETF	106.24	106.25	106.08	106.25	333491.0
2009-10-30 08:00:00	SPY	ETF	106.26	106.65	105.96	106.18	759761.0
2009-10-30 08:30:00	SPY	ETF	106.31	106.42	106.13	106.14	1828158.0
2009-10-30 09:00:00	SPY	ETF	106.14	106.31	106.07	106.3	1308734.0
2009-10-30 09:30:00	SPY	ETF	106.3	106.62	105.74	105.91	39778832.0
2009-10-30 10:00:00	SPY	ETF	105.92	106.38	105.84	105.95	18050131.0
2009-10-30 10:30:00	SPY	ETF	105.95	106.07	105.62	106.02	13210789.0
2009-10-30 11:00:00	SPY	ETF	106.02	106.03	105.6	105.665	10767071.0
2009-10-30 11:30:00	SPY	ETF	105.67	105.79	104.7	104.99	24617588.0
2009-10-30 12:00:00	SPY	ETF	104.99	105.27	104.28	104.38	23616921.0
2009-10-30 12:30:00	SPY	ETF	104.38	104.65	103.8	103.96	28884591.0
2009-10-30 13:00:00	SPY	ETF	103.96	104.405	103.93	104.06	19375857.0
2009-10-30 13:30:00	SPY	ETF	104.04	104.19	103.59	103.91	17156530.0
2009-10-30 14:00:00	SPY	ETF	103.9	104.52	103.89	104.16	18868014.0
2009-10-30 14:30:00	SPY	ETF	104.16	104.19	103.73	104.02	15072865.0
2009-10-30 15:00:00	SPY	ETF	104.02	104.045	103.44	103.82	27435657.0
2009-10-30 15:30:00	SPY	ETF	103.82	104.32	103.63	103.63	47071171.0
2009-10-30 16:00:00	SPY	ETF	103.64	106.34	103.45	103.68	12907688.0
2009-10-30 16:30:00	SPY	ETF	103.68	103.76	103.6	103.73	2445321.0
2009-10-30 17:00:00	SPY	ETF	103.73	103.76	103.62	103.69	135879.0
2009-10-30 17:30:00	SPY	ETF	103.69	103.73	103.56	103.7	96613.0
2009-10-30 18:00:00	SPY	ETF	103.7	103.74	103.65	103.74	29392.0
2009-10-30 18:30:00	SPY	ETF	103.74	103.8	103.7	103.8	14778.0
2009-10-30 19:00:00	SPY	ETF	103.8	103.8	103.7	103.71	11400.0
2009-10-30 19:30:00	SPY	ETF	103.73	103.75	103.69	103.7	18260.0
2009-10-30 07:00:00	QQQ	ETF	42.0	42.01	41.99	42.0	10400.0
2009-10-30 07:30:00	QQQ	ETF	41.98	41.98	41.91	41.97	9500.0
2009-10-30 08:00:00	QQQ	ETF	41.98	42.09	41.86	42.01	162110.0
2009-10-30 08:30:00	QQQ	ETF	42.0	42.07	41.96	41.98	563252.0
2009-10-30 09:00:00	QQQ	ETF	41.97	42.06	41.92	42.06	1223176.0
2009-10-30 09:30:00	QQQ	ETF	42.06	42.15	41.83	41.96	19990792.0
2009-10-30 10:00:00	QQQ	ETF	41.965	42.14	41.95	41.99	10357010.0
2009-10-30 10:30:00	QQQ	ETF	41.99	42.05	41.86	42.01	7252806.0
2009-10-30 11:00:00	QQQ	ETF	42.01	42.02	41.79	41.7996	5479818.0
2009-10-30 11:30:00	QQQ	ETF	41.8	41.84	41.34	41.47	13377439.0
2009-10-30 12:00:00	QQQ	ETF	41.47	41.56	41.22	41.25	10475202.0
2009-10-30 12:30:00	QQQ	ETF	41.25	41.38	41.02	41.1	16208882.0
2009-10-30 13:00:00	QQQ	ETF	41.09	41.26	41.0719	41.17	11123453.0
2009-10-30 13:30:00	QQQ	ETF	41.16	41.23	40.95	41.12	11649436.0
2009-10-30 14:00:00	QQQ	ETF	41.12	41.32	41.11	41.1885	9467682.0
2009-10-30 14:30:00	QQQ	ETF	41.19	41.23	41.03	41.17	6813625.0
2009-10-30 15:00:00	QQQ	ETF	41.16	41.175	40.92	41.061	10562668.0
2009-10-30 15:30:00	QQQ	ETF	41.07	41.25	40.96	40.97	18680442.0

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

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